This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I'm trying to work on a script that will save the message tracking results on a per-recipient basis. I am filtering on the DELIVER event, but users on the same database will show as a collection. What's the easiest way to get the results from the first set of data look like the second set of data, i.e. one entry per recipient? On-prem 2016 CU20
I want to get the data in the form of a hash that can be used elsewhere in the script.
EventID Sender MessageSubject Recipients
DELIVER joe@keyman .com Test Email bob@Company portal .com
DELIVER joe@keyman .com Test Email sue@Company portal .com
DELIVER joe@keyman .com Test Email {pam@constoso.com,bill@Company portal .com,jill@Company portal .com}
DELIVER joe@keyman .com Test Email rick@Company portal .com
EventID Sender MessageSubject Recipients
DELIVER joe@keyman .com Test Email bob@Company portal .com
DELIVER joe@keyman .com Test Email sue@Company portal .com
DELIVER joe@keyman .com Test Email pam@Company portal .com
DELIVER joe@keyman .com Test Email bill@Company portal .com
DELIVER joe@keyman .com Test Email jill@Company portal .com
DELIVER joe@keyman .com Test Email rick@Company portal .com
You can use script below to expand {pam@constoso.com,bill@Company portal .com,jill@Company portal .com}:
$temps = Get-TransportService | Get-MessageTrackingLog -Sender User@domain.com -MessageSubject "test7/5" -EventId DELIVER
Foreach ($temp in $temps) {
$i = 0
while ($temp.Recipients[$i] -ne $null) {
Write-host $temp.EventID $temp.Sender $temp.MessageSubject $temp.Recipients[$i] $temp.Timestamp
$i++
}
}
By the way, Exchange Q&A forum doesn't support writing script according to needs so far. If you have more requirements about scripts, I suggest you open a ticket to Microsoft to get a more professional script.
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
@davrion
I am writing here to confirm with you any update about this thread now?
If the above suggestion helps, please be free to mark it as an answer for helping more people.
II can see that the steps will output the results to the screen. What I'm after is having the results in a hash table, as I want to reference the results further down in the script? So if the original results were in $temps, then I'd like to get the results in $temps2 for example.
You can use “>>c:/temp/result.txt” to export result to a file. If you want another specific format, you may need to open a ticket to Microsoft for getting a more professional script.