Output Exchange Message Tracking Log to CSV or Excel

I needed to output the Microsoft Exchange 2010 Message Tracking Log to CSV, here's the Exchange PowerShell command I used:

get-messagetrackinglog -Start "07/09/2010 00:00:00" -End "07/09/2010 23:59:00" 
-resultSize unlimited | select timestamp, sender, {$_.recipients}, messagesubject, 
internalmessageid, clientid, clienthostname, serverip, serverhostname, connectorid, 
{$_.recipientstatus}, totalbytes, recipientcount, relatedrecipientaddress, 
{$_.reference}, returnpath, messageinfo | export-csv c:\results.csv
Author Paul Hayman

Paul is the COO of kwiboo ltd and has more than 20 years IT consultancy experience. He has consulted for a number of blue chip companies and has been exposed to the folowing sectors: Utilities, Telecommunications, Insurance, Media, Investment Banking, Leisure, Legal, CRM, Pharmaceuticals, Interactive Gaming, Mobile Communications, Online Services.

Paul is the COO and co-founder of kwiboo (http://www.kwiboo.com/) and is also the creator of GeekZilla.

Add Comment

Name
Comment
 

Your comment has been received and will be shown once it passes moderation.