Create delivery reports from Message Tracking Log in Exchange 2010

By default, Exchange 2010 keeps 30 days of Message Tracking logs.  These logs are typically used for troubleshooting delivery problems, but you can generate delivery reports from them as well.  The following Powershell command returned all emails sent to the undergraduate population for as far back as we had data (no -Start or -End qualifiers were specified).

Get-ExchangeServer | where {$_.IsHubTransportServer -eq “true”} | Get-MessageTrackingLog -Recipients:undergraduatestudents@domain.edu -EventId “RECEIVE” | select TimeStamp,Sender,{$_.recipients},MessageSubject | Export-Csv C:\undergraduatestudents.csv

The “{$_.recipients},” in the above command is optional since we’re already searching for all messages sent to undergraduatestudents@domain.edu.  It does tell you who else received a given message, however

Reference: http://blogs.technet.com/b/exchange/archive/2008/12/01/3406581.aspx

About Robert Blissitt

BF-ITS(Systems)
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>