Solved

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

Posted on 2009-04-02
2
2,160 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

The curse of the end user strikes again      

You’ve updated all your end user’s email signatures. Hooray! But guess what? They’re playing around with the HTML, adding stupid taglines and ruining the imagery. Find out how you can save your signatures from end users today.

Join & Write a Comment

Suggested Solutions

Utilizing an array to gracefully append to a list of EmailAddresses
Resolve Outlook connectivity issues after moving mailbox to new Exchange 2016 server
In this video we show how to create a Resource Mailbox in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: Navigate to the Recipients >> Resources tab.: "Recipients" is our default selection …
how to add IIS SMTP to handle application/Scanner relays into office 365.

758 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

18 Experts available now in Live!

Get 1:1 Help Now