• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 321
  • Last Modified:

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!
0
mrosier
Asked:
mrosier
  • 5
  • 4
3 Solutions
 
Gary DewrellSenior 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
 
Gary DewrellSenior 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
Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

 
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
 
mrosierAuthor 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

Featured Post

Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now