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