Jump to content

Iqu

Member
  • Posts

    20
  • Joined

  • Last visited

Awards

This user doesn't have any awards

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. so i changed the energy settings to "Ultimate Performance" and still nothing
  2. Hey Guys, really simple question: My i7 8700 is only clocking at 800MHz no matter what settings I configure in my BIOS. My I7 8700 is paired with an Maximus XI Formula and 32GB 3200MHz CL16-18-18-36 Corsair Vengance My BIOS is up to date on version 1502. Anyone got a Solution for my Problem? Thanks alot! Cheers ~Iqu
  3. yeah i know .... i can just change the command to get-messagetrackinglog -Start "2-3-2020" -End "2-6-2020" -MessageSubject "Bills" -sender: "sender1@anonymous.com" | Select messagesubject,recipients,eventid | Out-File 'C:\Temp\MessageLogs\LogSender1.csv' and I´m good to go... But it doesn´t really matter, if I have my Logs as .txt files or as .csv files... cause i need to import them either way into another excel sheet, which is continueing with some calulations of several other Billnumbers. But I also was thinking about doin the "splitting part" in VBA cause that seems a lot easier for me than with powershell, since I´m not too comftable in the handling with PowerShell. Because in VBA you already have the "split" function which u can use to divide a long string into several shorter ones. But still thx for the advice
  4. and for what exactly does the (.+) and the \s(\d+) stand? sry im new with powershell and aint knowing too much so far
  5. Hm thats the Problem ... in this case the Billnumber is a digit number ... but it can also be a 8 or 15 digit number... can i use the -match attribute like this: -match "(.+\s(\d{$variable})" ? so that the length of the Billnumber is a variable? Greetings and thanks for the fast anwser
  6. Hey Guys, its me again I need help with some PowerShell scripting... my current PS Script looks like that: echo "" echo "If this Message is seen, the Event Button.Click worked" $Cred = Get-Credential $Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri http://[*Remoteconnection to my Server*]/PowerShell/ -Authentication Kerberos -Credential $Cred Import-PSSession $Session get-messagetrackinglog -Start "2-3-2020" -End "2-6-2020" -MessageSubject "Bills" -sender: "sender1@anonymous.com" | Select messagesubject,recipients,eventid | Out-File 'C:\Temp\MessageLogs\LogSender1.txt' get-messagetrackinglog -Start "2-3-2020" -End "2-6-2020" -MessageSubject "Bills" -sender: "sender2@anonymous.com" | Select messagesubject,recipients,eventid | Out-File 'C:\Temp\MessageLogs\LogSender2.txt' get-messagetrackinglog -Start "2-3-2020" -End "2-6-2020" -MessageSubject "Bills" -sender: "sender3@anonymous.com" | Select messagesubject,recipients,eventid | Out-File 'C:\Temp\MessageLogs\LogSender3.txt' echo "This script was executed on Windows Server 2012 R2 - MS Exchange 2013." echo "" Pause It creates a Log file that looks like this: It shows the entered attributes "MessageSubject", "Recipients" and "EventID" and the connect data-value for each attribute. And my question now is, wether or not it is possible, to let PowerShell divide the "MessageSubject-Value" into 2 Substrings (like 1. "Company: Bill" and 2. "0133456789") so I can easily, after the Import into MS Excel, devide the data-value of MessageSubject into 2 Cells. I need that, because in my VBA script, the Cells, where only the Billnumber is located in, is used for upcomming calculations and controlstructures like IF-ELSE or switch-case structures. Does anyone has an idea on how to solve my Problem?
×