Wednesday, May 18, 2011

How to Export Exchange Message Tracking Logs to Excel

imageFrom time to time you may have a user request to find out what messages they should have received - perhaps they have marked them as Junk Email in Outlook, or deleted them accidentally. Whatever the reason, you might find it useful to be able to quickly pull the information for the user out of the message tracking logs and into a file quickly so they can have a look for themselves.

What this script does is searches for messages delivered to a particular user across all Hub Transport servers, sorts the information by the date and time and saves it to a convenient CSV file ready to open in Microsoft Excel.

How to use the script

Whilst the script is in use, you'll see progress of each log search:
image

After completion you should find your resulting CSV file similar to this:
image

Script Code

Script Download
Download Export-MessageTrackingLogsForRecipient.zip

No comments:

Post a Comment