Solved

outgoing mail logs in Exchange 2010

Posted on 2014-03-24
9
307 Views
Last Modified: 2014-03-29
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
Comment
Question by:mrosier
[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
  • 5
  • 4
9 Comments
 
LVL 12

Assisted Solution

by:Gary Dewrell
Gary Dewrell earned 500 total points
ID: 39950307
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
 

Author Comment

by:mrosier
ID: 39950347
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
 
LVL 12

Accepted Solution

by:
Gary Dewrell earned 500 total points
ID: 39950382
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
Office 365 Training for IT Pros

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.

 
LVL 12

Expert Comment

by:Gary Dewrell
ID: 39950390
An example might be something like:
get-messagetrackinglog -sender youremail@yourdomain.com -start "03/22/2014" | fl Sender, Recipients, timestamp
0
 

Author Comment

by:mrosier
ID: 39950415
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
 
LVL 12

Expert Comment

by:Gary Dewrell
ID: 39950442
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
 

Assisted Solution

by:mrosier
mrosier earned 0 total points
ID: 39950475
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
 
LVL 12

Expert Comment

by:Gary Dewrell
ID: 39950481
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
 

Author Closing Comment

by:mrosier
ID: 39963529
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

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

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

Following basic email etiquette rules will help you write a professional email and achieve a good, lasting impression with your contacts.
Read this checklist to learn more about the 15 things you should never include in an email signature.
In this video we show how to create an Accepted Domain 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 Mail Flow >> Ac…
how to add IIS SMTP to handle application/Scanner relays into office 365.

729 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