outgoing mail logs in Exchange 2010

Hello! I would like to go into my Exchange logs and ideally check out who mail is being sent to from specific users. I am using Exchange 2010 with all the updates. Does Exchange log where mail is sent and from whom or would I have to enter the mailboxes as admin and look in sent mail folders? Thanks!
mrosierAsked:
Who is Participating?
 
Gary DewrellConnect With a Mentor Senior Network AdministratorCommented:
Absolutely. And a whole lot more.  Take a look here and make sure you expand the Parameters table.

http://technet.microsoft.com/en-us/library/aa997573(v=exchg.150).aspx
0
 
Gary DewrellConnect With a Mentor Senior Network AdministratorCommented:
Yes it logs who sent mail and to whom it was sent.
Look at the get-messagetrackinglog command.

A better solution is to get some type of mail reporting system that will give you the reports you like.

We use MessageStats from Quest.
0
 
mrosierAuthor Commented:
great thanks for the info! a couple more questions about using this command. Is there a way to see a timestamp on the results? Also, I am not sure how to use EventID and Source? I really just want to see whatever this user sent and I get the feeling that I am getting more than that. Can you recommend a good article explaining everything for this command as to syntax and what I am looking at in results?
0
Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

 
Gary DewrellSenior Network AdministratorCommented:
An example might be something like:
get-messagetrackinglog -sender youremail@yourdomain.com -start "03/22/2014" | fl Sender, Recipients, timestamp
0
 
mrosierAuthor Commented:
great thanks for the info again! I am set but I have one last question after looking through some things. I cannot seem to find a way to export this to an Excel file or CSV file. Is this possible? OR if I can just create a file out of this command?
0
 
Gary DewrellSenior Network AdministratorCommented:
Yes you can.

get-messagetrackinglog -sender youremail@yourdomain.com -start "03/22/2014" | select Sender, Recipients, timestamp | export-csv -path c:\temp\mailreport.csv
0
 
mrosierConnect With a Mentor Author Commented:
excellent thanks for all the info! I would suggest future users to refer to this article as well: http://anandthearchitect.com/2012/07/06/exchange-2010-how-to-export-message-tracking-results-to-excel-sheet/ because some extra syntax is needed to retrieve the recipient addresses in my question. If I just export as is, the recipient column in the exported data just has “System.String[]” in every cell in that column. That article gives some extra to get the names in there. Unless you have something easier, gdewrell?
0
 
Gary DewrellSenior Network AdministratorCommented:
Nope. You are correct and my apologies for not explaining better. Expanding the recipient list does take an extra step.

Have a blessed day!.
0
 
mrosierAuthor Commented:
I got everything I need from this solution. I noted one of my messages just to be sure people see the article for a little bit more information to get a complete result that can be assumed they want.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.