Solved

How to export Exchange 2003 System Manager 'Message Tracking Center' query

Posted on 2009-04-02
2
2,189 Views
Last Modified: 2012-05-06
I am trying to export all emails from a specific email on a specific day into a clean file.  The Message Tracking Center does not appear to allow me to export the query into any sort of file.  I realize that there are log files of all activity from the entire day, but I was hoping for a quick way to get just the information I wanted exported.  I have downloaded the Log Parser, but I am not sure what sql statement will pull the information that I want.

Anyone have a quick way to export this?  Or if anyone has any experience writing the sql statements for Log Parser that will work too.
0
Comment
Question by:accellis
2 Comments
 
LVL 9

Accepted Solution

by:
Veerappan Sundaram earned 250 total points
ID: 24058301
All the message tracking logs will be stored under a folder name with the server name. Example: if your server name is "USEX01" then you can find shared folder called USEX01.log
Copy this file to your local computer and import the log file into Excel 2007/Access to view the logs in readable format.
>>>>Veera.
0
 

Author Closing Comment

by:accellis
ID: 31565989
This makes the log file manageable, thanks.
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

Suggested Solutions

Title # Comments Views Activity
SBS 2011 - Exchange - Can't received internal 1 34
EXCHANGE 2013, EXCHANGE 2007 6 38
Exchange 2016 2 29
Export Exchange 2007 Export Shared Mailboxes list 3 12
Lotus Notes – formerly IBM Notes – is an email client application, while IBM Domino (earlier Lotus Domino) is an email server. The client possesses a set of features that are even more advanced as compared to that of Outlook. Likewise, IBM Domino is…
This article explains how to install and use the NTBackup utility that comes with Windows Server.
In this video we show how to create an email address policy 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…
To show how to create a transport rule 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 >> Rules tab.:  To cr…

685 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