Logparser for Exchange Message Tracking

Here is that code you were asking for.

Parsing logs from Yesterday to Today (that spans 2 days for you who are counting)
Script generated for a batch file.
Echo is turned off in the batch file.
If output file myfile.tab already exists, it will be overwritten.
I will need files 20100905.log through 20100906.log.

@echo off
:: Script Generated by Johan Greefkes.
:: Visit http://www.anonymoos.com/logparser.php
echo. 
echo Parsing 20100905.log. . . 
"c:Program FilesLog Parser 2.2LogParser.exe" -i:W3C -o:TSV "select TO_TIMESTAMP( STRCAT( '2010-09-05', STRCAT(' ', STRREV( SUB( STRREV( TIME ) , 'TMG ') ))),'yyyy-MM-dd h:m:s') AS DateTime, Recipient-Address AS RcptAddress, MSGID, Number-Recipients AS NumRcpts, Message-Subject AS Subject, Sender-Address AS Sender from 20100905.log to myfile.tab WHERE Message-Subject NOT LIKE '%%virus found%%' AND recipient-Address LIKE '%%@%%' GROUP BY DateTime, MSGID, Recipient-Address, Number-Recipients, Message-Subject, Sender-Address" -filemode:1
echo. 
echo Parsing 20100906.log. . . 
"c:Program FilesLog Parser 2.2LogParser.exe" -i:W3C -o:TSV "select TO_TIMESTAMP( STRCAT( '2010-09-06', STRCAT(' ', STRREV( SUB( STRREV( TIME ) , 'TMG ') ))),'yyyy-MM-dd h:m:s') AS DateTime, Recipient-Address AS RcptAddress, MSGID, Number-Recipients AS NumRcpts, Message-Subject AS Subject, Sender-Address AS Sender from 20100906.log to myfile.tab WHERE Message-Subject NOT LIKE '%%virus found%%' AND recipient-Address LIKE '%%@%%' GROUP BY DateTime, MSGID, Recipient-Address, Number-Recipients, Message-Subject, Sender-Address" -filemode:0

Select all text and copy the text, then paste into a text file and save it with either a bat or cmd extension.

Start Over