Howto: Filter Message Tracking logs in Microsoft Exchange using Powershell


Today I’ve been working with a vendor, trying to figure out why not all of my client’s users are receiving a certain notification email. I enabled message tracking in Exchange 2003, but it creates a log file that’s in a fairly unreadable format.

I found this post that describes using the Microsoft Log Parser utility to run SQL queries against the message tracking logs. Even after reading the documentation and unofficial Log Parser reference site, I was having difficulties constructing the queries; I just wanted to know who received the email and what date and time they got it.

WindowsITpro.com had an article on Log Parser, but since I don’t subscribe to their site, I only got the first few paragraphs of the article.

This batch file generator gave me too much information. It seemed like exporting this information was way more difficult than it should have been.

Then I came across this Powershell script Glen wrote that generates a form that allows you filter the message tracking log files based on your criteria. It took all of three minutes to download and run, and I was able to save the information into a .csv file. Brilliant!

One more thing… if you want to use message tracking on an Exchange 2000 cluster, see Microsoft KB327977. And if your inetinfo.exe utilization suddenly goes through the roof, check out Microsoft KB811409. Both of these issues appear to be resolved in KB813840.

[updated 06-29-2007]

I found another Exchange log search tool. It doesn’t use Powershell, and I haven’t used it personally, but I would love to hear if it works or not.

4 Responses to “Howto: Filter Message Tracking logs in Microsoft Exchange using Powershell”

  1. Weekend reading - subject: exchange Says:

    [...] Howto: Filter Message Tracking logs in Microsoft Exchange using Powershell [...]

  2. Message Tracking in Microsoft Exchange using Powershell | Log Parser Watch Says:

    [...] here: Message Tracking in Microsoft Exchange using Powershell extension, firefox, freeware, google, hardware, howto, log parser, logs, script, techextension, [...]

  3. Chap Says:

    Had a go with http://www.arconi.com/Exchange_Log_Searcher.html by the way and it works fine if a little limited. Easier than banging your head against SQL.

  4. Brian Scott Says:

    The Exchange Log Search Tool has issues parsing log files with over 10,000 lines. I don’t recommend using it, maybe for smaller log files.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 32 other followers

%d bloggers like this: