Reporting from Exchange

jenniferbillington
jenniferbillington used Ask the Experts™
on
I am looking for a way with Exchange 2010 to run a report on a specific mailbox group, a list of all sent and received emails, with date and times.  I want to export to csv for statistical purposes.  Is this possible with Exchange Management console?  Is there another application I can do this with easily?

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
You can try following command.

Get-MessageTrackingLog -Start "03/13/2010 09:00:00" -End "03/15/2010 17:00:00" -Sender "user@domain.com"

Author

Commented:
I tried from the shell:

Get-MessageTrackingLog -Start "02/01/2014 00:00:00" -End "02/24/2014 23:59:59" -Sender "user@domain.com" | export-csv c:\february.csv

File is empty.
strange.. Its working in my setup.

#TYPE Microsoft.Exchange.Management.TransportLogSearchTasks.MessageTrackingEvent
"PSComputerName","RunspaceId","Timestamp","ClientIp","ClientHostname","ServerIp","ServerHostname","SourceContext","ConnectorId","Source","EventId","InternalMessageId","MessageId","Recipients","RecipientStatus","TotalBytes","RecipientCount","RelatedRecipientAddress","Reference","MessageSubject","Sender","ReturnPath","MessageInfo","MessageLatency","MessageLatencyType","EventData"
"Exch.domain.com","07092d1f-15dd-4a34-8daf-4a1917d869ed","25-02-2014 22:30:14","1.1.64.121","Exch","","Exch","MDB:2f2f7e72-131b-4cb5-8574-9b4e9044f10a, Mailbox:9caf88c6-922d-48ba-ad73-1a13667178fc, Event:1026707, MessageClass:IPM.Note, CreationTime:2014-02-25T17:00:12.248Z, ClientType:MOMT","","STOREDRIVER","SUBMIT","","<A8B08322006C59459A45A182430DE7FCEB8EF3@Exch.domain.com>","System.String[]","System.String[]",,,"",,"e","prox14@domain.com","","2014-02-25T17:00:12.248Z;LSRV=Exch.domain.com:TOTAL=2|MSSN=1","00:00:02.4540000","LocalServer","System.Collections.Generic.KeyValuePair`2[System.String,System.Object][]"
"Exch.domain.com","07092d1f-15dd-4a34-8daf-4a1917d869ed","25-02-2014 22:30:14","1.1.64.121","Exch.domain.com","1.1.64.121","Exch","08D0FBE3D6783EE0","","STOREDRIVER","RECEIVE","30","<A8B08322006C59459A45A182430DE7FCEB8EF3@Exch.domain.com>","System.String[]","System.String[]","5746","1","",,"e","prox14@domain.com","prox14@domain.com","04I: ",,"None","System.Collections.Generic.KeyValuePair`2[System.String,System.Object][]"
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
I tried it on an individual and it exported some data, but the group doesn't report anything.
Try
Get-MessageTrackingLog -Start "03/13/2010 09:00:00" -End "03/15/2010 17:00:00" -Recipients "user@domain.com"

Author

Commented:
That did it.  Thanks!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial