Solved

outgoing mail logs in Exchange 2010

Posted on 2014-03-24
9
296 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
  • 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
 
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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

Don't lose your head updating email signatures!

Do your end users still have the wrong email signature? Do email signature updates bore you or fill you with a sense of dread? You can make this a whole lot easier on yourself by trusting an Exclaimer email signature management solution. Over 50 million users do...so should you!

Question has a verified solution.

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

Marketers need statistics and metrics like everybody else needs oxygen. In this article we explain how to enable marketing campaign statistics for Microsoft Exchange mail.
Learn to move / copy / export exchange contacts to iPhone without using any software. Also see the issues in configuration of exchange with iPhone to migrate contacts.
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…
In this video we show how to create a mailbox database 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 >> Data…

911 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now