Solved

Exchange Message Tracking

Posted on 2014-01-21
7
355 Views
Last Modified: 2014-01-23
I have a manager that needs a list of all mail sent to a particular mailbox. She needs to see the sender, date, and subject line. Is there a way that this can be accomplished in exchange 2010 and then exported to an excel spreadsheet.
0
Comment
Question by:timgreen7077
  • 3
  • 2
7 Comments
 
LVL 17

Assisted Solution

by:Chris Millard
Chris Millard earned 250 total points
ID: 39797295
Right, I'll try and get you through this as best I can! This is assuming that you have message tracking enabled.

On the server, open the Exchange Management Console

From the left hand menu, highlight "Toolbox", and in the right hand window, double click "Tracking Log Explorer"

Under the Message Tracking Parameters, choose Recipients, and enter the email address of the mailbox you want the details from.

Event ID should be "Receive".

Set the start and end dates for your search and click next.

On the next page, you should see a grid with your results in it.

On the left hand menu, choose the option which says "Select a result file to view" - and when it says that this will stop the current task, say OK to that.

What you should see is a list of results of searches you have made in the past (the top most should be the last one that you just ran).

Click on the top entry, and you'll see a few options - one of which is "Export Results". This will give you the option of saving the results to an XML file wherever you choose.

You will then have to find an appropriate way of converting that XML file to a CSV (such as the free online converter at http://www.luxonsoftware.com/converter/xmltocsv)
0
 
LVL 53

Accepted Solution

by:
Will Szymkowski earned 250 total points
ID: 39797349
You can use powershell to accomplish this. Use the following syntax below...

Get-MessageTrackingLog -Server <hub transport servername> -ResultSize "unlimited" -Recipients username@domain.com | select Sender, Recipient, MessageSubject | Export-Csv -NoTypeInformation c:\emailmessages.csv

Open in new window


You will be restricted with the history based on the message tracking settings you have setup in your environment. The default is 30 days.

Will.
0
 

Author Comment

by:timgreen7077
ID: 39797716
Will Szymkowski how do you add a search range based on the date you choose and how do you get the date to show in the .cvs file
0
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
LVL 53

Expert Comment

by:Will Szymkowski
ID: 39797958
You already accepted the above answer :-(

Anyways add the -start "mm/dd/yyyy 1:00AM" -end "mm/dd/yyyy 4:00PM"  after the -Server switch.

Also to add the fields add the following to select

select Sender, Recipient, MessageSubject, Start, End

Will.
0
 

Author Comment

by:timgreen7077
ID: 39799745
the fields are created in the excel spreadsheet but they are not being populated. The only fields being populated are sender, messagesubject. This is the cmdlet I'm using:

Get-MessageTrackingLog -Server houvxhc1 -start "10/01/2013 12:00AM" -end "01/21/2014 3:03PM" -ResultSize "unlimited" -Recipients accountspayable@domain.com | select Sender, Recipients, MessageSubject, start, end | Export-Csv -NoTypeInformation c:\email\emailmessages.csv

Can anything be added or changed in order for the Recipient and Date will also populate in the csv spreadsheet.

Also I asked the messaged the moderator to reopen the ticket.

Thanks
0
 

Author Comment

by:timgreen7077
ID: 39799859
The correct word is timestamp, and that populated the date and time in the csv. Thanks for all your help and i'm waiting on the moderator to reply.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Local Continuous Replication is a cost effective and quick way of backing up Exchange server data. The following article describes the steps required to configure Local Continuous Replication. Also, the article tells you how to restore from a backup…
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 a Distribution Group 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 Recipients >>…
This video demonstrates how to sync Microsoft Exchange Public Folders with smartphones using CodeTwo Exchange Sync and Exchange ActiveSync. To learn more about CodeTwo Exchange Sync and download the free trial, go to: http://www.codetwo.com/excha…

910 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

24 Experts available now in Live!

Get 1:1 Help Now