logparser script not reporting on outbound errors
I wrote this script using log parser to extract data from the exchange data base to report outbound errors It has been running every week without fail. About three weeks ago it stopped running. This is a cmd file that runs using windows schedular when it runs now it just sits on the screen blank until I hit hit several times then it completes the report is bleow the script As you can see in the report it ran for over 2 hrs thats becasue it just sat there until I hit enter. Is it becasue of no records found? or do I have a problem? Any ideas or thoughts Thanks @echo off del smtp2.txt "C:\Program Files (x86)\Log Parser 2.2\logparser.exe" "SELECT CASE TO_INT( SUBSTR(DATA,0,3)) when NULL then 0 else TO_INT( SUBSTR(DATA,0,3)) END AS RemoteHostReturnCode, data, count (*) AS hits FROM C:\Progra~1\Microsoft\Exchan~1\TransportRoles\Logs\ProtocolLog\SmtpSend\SEND*.log WHERE RemoteHostReturnCode > 400 AND context <> 'Certificate thumbprint' AND context <> 'sending message' GROUP BY RemoteHostReturnCode, data ORDER BY hits DESC" -i:CSV -nSkipLines:4 -o:w3c >c:\util\smtp2.txt C:\util\febooti\febootimail -from server5@mydomain.com -to support@mydomain.com -msg "Outbound Errors" -subj "SMTP Send Outbound Errors Log" -attach smtp2.txt -smtp 192.168.1.26 Exit Report: #Software: Microsoft Log Parser #Version: 1.0 #Date: 2012-04-10 19:05:00 #Fields: RemoteHostReturnCode data hits 451 451-http://www.commtouch.com/Site/Resources/Check_IP_Reputation.asp. Reference 13 451 451-Delivery from xx.xx.xxx.xx is deferred. Send again or check at 13 451 451 code: tid=0001.0A020303.4F71265F.0023 1 451 451 code: tid=0001.0A020303.4F71261D.0086 1 451 451 code: tid=0001.0A020302.4F7125DC.0042 1 451 451 code: tid=0001.0A020303.4F71259B.0010 1 451 451 code: tid=0001.0A020302.4F7126A0.0074 1 451 451 code: tid=0001.0A020302.4F712559.0069 1 451 451 code: tid=0001.0A020303.4F7124D6.009D 1 451 451 code: tid=0001.0A020302.4F712495.004E 1 Press a key... 451 451 code: tid=0001.0A020301.4F712454.0028 1 451 451 code: tid=0001.0A020303.4F712412.0080 1 451 451 code: tid=0001.0A020303.4F7123D1.0053 1 451 451 code: tid=0001.0A020303.4F712391.002C 1 451 451 code: tid=0001.0A020303.4F712518.003B 1 Statistics: ----------- Elements processed: 1777 Elements output: 15 Execution time: 7689.08 seconds (02:08:9.08) Thomas R Grassi Jr
April 11th, 2012 9:54am

Hi Thomas, Could you please run the logpaser with a simpler query to make sure the application is not corrupted first? Otherwise you have to reinstall it.Frank Wang TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
April 12th, 2012 5:23am

Frank If you are think logparser is the problem I forgot to mention I have several other queries that I run on a scheduled basis and they all work fine. Any other thoughts or suggestions? Thomas R Grassi Jr
April 12th, 2012 8:03am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics