Get-MessageTrackingLog against all Exchange Servers For Bulk a List of e-mail addresses EX 2016

Question

Get-MessageTrackingLog against all Exchange Servers For Bulk a List of e-mail addresses EX 2016

MTS 26

I have been trying to perform this action using various scripts but i cant seem to get it all together working correctly.

i basically need to run a message tracking log against 300 mailboxes that sit across 8 exchange servers.

any help would be greatly appreciated

i stripped it back down to do a test for one mailbox as follows

Get-OPTransportServer | Get-OPMessageTrackingLog -Start "05/01/2023 09:00:00" -End "11/02/2023 17:00:00" -Recipients t ******@test.com

which is giving me message trace results but basically i need to apply that to a list of mailboxes from a CSV

Rich Matheisen 47,901 Reputation points

2023-11-02T18:03:53.54+00:00

Are Get-OPTransportServer and Get-OPMessageTrackingLog something you've written? They don't appear to be the Exchange cmdlet names.

Message tracking logs are just CSV files, each row of which is an event (there are usually multiple events for each message), so looking for recipients should be easy.

Looking for a list of 300 addresses using something like "$addresses -contains <address from tracking log event>" would probably add a lot of processing overhead, though. I'd create a hash with the keys of those 300 addresses and then check the hash for the recipient address in the log event.
Yuki Sun-MSFT 41,376 Reputation points Moderator

2023-11-17T07:13:31.86+00:00

Hi @MTS ，

Just checking in to see if the answer helped. If this answers your query, please don’t forget to click "Accept Answer" which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Accepted answer

0 additional answers

Your answer

Rich Matheisen 47,901 Reputation points

2023-11-02T18:03:53.54+00:00

Are Get-OPTransportServer and Get-OPMessageTrackingLog something you've written? They don't appear to be the Exchange cmdlet names.

Message tracking logs are just CSV files, each row of which is an event (there are usually multiple events for each message), so looking for recipients should be easy.

Looking for a list of 300 addresses using something like "$addresses -contains <address from tracking log event>" would probably add a lot of processing overhead, though. I'd create a hash with the keys of those 300 addresses and then check the hash for the recipient address in the log event.
Yuki Sun-MSFT 41,376 Reputation points Moderator

2023-11-17T07:13:31.86+00:00

Hi @MTS ，

Just checking in to see if the answer helped. If this answers your query, please don’t forget to click "Accept Answer" which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Answer 1

Hi @MTS ，

i basically need to run a message tracking log against 300 mailboxes that sit across 8 exchange servers.

Prepare a csv file for the mailboxes list using format below (a column header named "Email" and a row for each mailbox email address):
User's image

Then you can use the following scripts to retrieve all the message tracking logs and export the result into a csv file:

$Mailboxes = Import-Csv -Path "C:\Mailboxes.csv"   
  foreach ($Mailbox in $Mailboxes) {         
       Get-TransportService | Get-MessageTrackingLog -Start "05/01/2023 09:00:00" -End "11/02/2023 17:00:00"  -Recipients $Mailbox.Email -ResultSize Unlimited |sort-object Timestamp | Export-Csv -Path "C:\TrackingLogs.txt"}

Note: Considering that the tracking logs contain multiple lines for each mail, and you are trying to run the command against 300 mailboxes over a period of several months, the output could be quite huge. So personally, I'd recommend trying to shorten the time range or add some more filter like -EventID "RECEIVE" after the Get-MessageTrackingLog.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

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.

Yuki Sun-MSFT 41,376 Reputation points Moderator

2023-11-06T08:38:57.82+00:00

Hi @MTS ，

I'm writing to check if your issue has been resolved. If the problem is successfully resolved, you can share your solution or accept post you find helpful as answer. This can be beneficial to others who reading this thread. If you need further assistance on this, please feel free to post back. Thanks!

Share via

Get-MessageTrackingLog against all Exchange Servers For Bulk a List of e-mail addresses EX 2016

0 additional answers

Your answer