Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2009-04-02
2
Medium Priority
?
2,239 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 1000 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

The core idea of this article is to make you acquainted with the best way in which you can export Exchange mailbox to PST format.
Steps to fix error: “Couldn’t mount the database that you specified. Specified database: HU-DB; Error code: An Active Manager operation fail”
The video tutorial explains the basics of the Exchange server Database Availability groups. The components of this video include: 1. Automatic Failover 2. Failover Clustering 3. Active Manager
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Suggested Courses

886 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