Solved

Reporting from Exchange

Posted on 2014-02-25
6
409 Views
Last Modified: 2014-02-25
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
0
Comment
Question by:jenniferbillington
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 3

Expert Comment

by:Krishna Patil
ID: 39886076
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"
0
 

Author Comment

by:jenniferbillington
ID: 39886145
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.
0
 
LVL 3

Expert Comment

by:Krishna Patil
ID: 39886181
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][]"
0
Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 

Author Comment

by:jenniferbillington
ID: 39886185
I tried it on an individual and it exported some data, but the group doesn't report anything.
0
 
LVL 3

Accepted Solution

by:
Krishna Patil earned 250 total points
ID: 39886205
Try
Get-MessageTrackingLog -Start "03/13/2010 09:00:00" -End "03/15/2010 17:00:00" -Recipients "user@domain.com"
0
 

Author Closing Comment

by:jenniferbillington
ID: 39886227
That did it.  Thanks!
0

Featured Post

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Scam emails are a huge burden for many businesses. Spotting one is not always easy. Follow our tips to identify if an email you receive is a scam.
Find out what you should include to make the best professional email signature for your organization.
To show how to generate a certificate request in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.:  First we need to log into the Exchange Admin Center. Navigate to the Servers >> Certificates…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

689 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question