Link to home
Start Free TrialLog in
Avatar of jenniferbillington
jenniferbillingtonFlag for United States of America

asked on

Reporting from Exchange

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
Avatar of Krishna Patil
Krishna Patil

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"
Avatar of jenniferbillington

ASKER

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][]"
I tried it on an individual and it exported some data, but the group doesn't report anything.
ASKER CERTIFIED SOLUTION
Avatar of Krishna Patil
Krishna Patil

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
That did it.  Thanks!