Thanks Jay!
-----Original Message----- From: Reische Jay [mailto:reische...@johndeere.com] Sent: Tuesday, March 02, 2010 8:35 AM To: MS-Exchange Admin Issues Subject: RE: Email tracking documentation Working With the Search Results Once you have a search which returns the results you need, you may want to convert those results into other formats, perhaps to use for reports or to provide information to others. PowerShell includes built-in cmdlets for re-formatting output data, and those can be used in conjunction with the Get-MessageTrackingLog cmdlet. For the 'Recipients', 'RecipentStatus' and 'Reference' properties it's necessary to convert the data so that it appears in the output files. To convert the results to CSV format you can pipe the search command to the Export-CSV cmdlet. This command will create a CSV file called C:\Temp\SearchResults.csv, exporting all the available fields: [PS] C:\>Get-MessageTrackingLog -Server EXCHANGE01 -EventID SEND -Sender j...@example.com -Recipients b...@example.net -Start 12/3/2009 -End 13/3/2009 | Select Timestamp, ClientIp, ClientHostname, ServerIp, ServerHostname, SourceContext, ConnectorId, Source, EventId, InternalMessageId, MessageId, {$_.Recipients}, {$_.RecipientStatus}, TotalBytes, RecipientCount, RelatedRecipientAddress, {$_.Reference}, MessageSubject, Sender, ReturnPath, MessageInfo | Export-CSV C:\Temp\SearchResults.csv This command will create a CSV file including only the timestamp, event ID, sender, recipients, and subject line: [PS] C:\>Get-MessageTrackingLog -Server EXCHANGE01 -EventID SEND -Sender j...@example.com -Recipients b...@example.net -Start 12/3/2009 -End 13/3/2009 | Select Timestamp, EventID, Sender, {$_.Recipients}, MessageSubject | Export-CSV C:\Temp\SearchResults.csv Alternatively, to convert the results to HTML you can pipe the search command to the ConvertTo-HTML cmdlet. Use this command to export the results to an HTML file showing the timestamp, event ID, sender, recipients, and subject line: [PS] C:\>Get-MessageTrackingLog -Server EXHUB-00-UK -EventID SEND -Sender j...@example.com -Recipients b...@example.net -Start 12/3/2009 -End 13/3/2009 | ConvertTo-Html Timestamp, EventID, Sender, {$_.Recipients}, MessageSubject | Set-Content C:\Temp\logs.html http://www.simple-talk.com/sysadmin/exchange/message-tracking-in-exchange-2007/ Jay Reische Enterprise Exchange Administrator Messaging, AD and DNS Phone: 309-748-9422 reische...@johndeere.com -----Original Message----- From: Steve Hart [mailto:sh...@wrightbg.com] Sent: Tuesday, March 02, 2010 10:25 AM To: MS-Exchange Admin Issues Subject: Email tracking documentation How do people handle requests for proof of email tracking in E2007? Is there a better way than screenshotting the tracking window?
