Solved

outgoing mail logs in Exchange 2010

Posted on 2014-03-24
9
300 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
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.

 
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

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.

Question has a verified solution.

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

This article explains in simple steps how to renew expiring Exchange Server Internal Transport Certificate.
Find out what you should include to make the best professional email signature for your organization.
In this Micro Video tutorial you will learn the basics about Database Availability Groups and How to configure one using a live Exchange Server Environment. The video tutorial explains the basics of the Exchange server Database Availability grou…
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

825 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