bgroom1969
asked on
Export messages from the MTC
Hello, is there a way to export messages that are retrieved from the Message Tracking Center in Exchange 2003 into a spreadsheet or other output medium? I have been tasked with seeing what messages have been sent from an outside source to our internal users, and I can pull up messages in the MTC. But I see no way of copying this data to an outside source. Any and all advice is most welcome.
You would need to pull the information from where the logs are stored. In the properties of the Server > General Tab, is the location of the log file. The logs are filed for an entire day -- for ever how many days you have set the logging for.
ASKER
We save our log files for 60 days, so I would have to go through 60 log files, only to see e-mail coming into our server? That seems like a lot of work for very little payoff.
Message tracking logs?
asp: http://www.outlookexchange.com/articles/glenscales/mtrackrs.asp
xml: http://blogs.brnets.com/michael/archive/2006/11/10/2525.aspx
Access: http://www.promodag.com/products/storelog/description.aspx
Or purchase something that will process the logs for you.
If you have the budget, then Quest Message Stats is the best. However don't look at it if you cannot afford it as everything else will look poor.
There is also Mail Detective and Promodag.
Simon.
asp: http://www.outlookexchange.com/articles/glenscales/mtrackrs.asp
xml: http://blogs.brnets.com/michael/archive/2006/11/10/2525.aspx
Access: http://www.promodag.com/products/storelog/description.aspx
Or purchase something that will process the logs for you.
If you have the budget, then Quest Message Stats is the best. However don't look at it if you cannot afford it as everything else will look poor.
There is also Mail Detective and Promodag.
Simon.
ASKER
Thanks for the links Sembee, I am trying the ASP route right now. We have Message Stats already, but it does not drill down that deep. I am looking to provide some type of list that compiles all e-mail coming from one sender (i.e Joe@anydomain.com) to any and all of our internal users (i.e Sally@mydomain.com, Shirley@mydomain.com, Harry@mydomain.com). Is this possible? I have spent hours looking for a way to do this, and so far have been unsuccessful.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That is exactly what I am up against. I am able to use Message Tracking Center to pick out the e-mails sent from a single outside sender, but I have no way of exporting that list of messages, who they went to, date sent, etc. I have just registered with Quest, I am awaiting the username and password, then I will get a user guide to work with this some more. Your assistance and guidance is most appreciated.
Bill
Bill
ASKER
On another note, Sembee, if I copy the log files to my local machine to run the ASP script you posted above, will that work provided I make the necessary changes in the script itself? Or does it need to run on the Exchange server?
I haven't used the ASP script myself, but I see no reason why they shouldn't work elsewhere. The log files are just flat.
Simon.
Simon.
ASKER
The ASP solution did not work for me. I copied the log files over to my laptop, modified the script accordingly, and ran the script. It failed to populate the database. I have an issue opened with Quest to see if they can assist in any way with Message Stats.