Solved

Logparser "Prompts Press A Key" Exchange 2010 SMTP Send Log

Posted on 2015-02-05
2
472 Views
Last Modified: 2015-02-05
Exchange Server 2010 Enterprise SP3 RU 8 64 bit
Windows 2008 R2 64 bit
Log Parser 2.2

create this logparser script

@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 D:\Progra~1\Microsoft\Exchan~1\V14\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

Exit

Open in new window



This was running on my exchange 2007 enterprise server and once in awhile I had this same issue.

The output show this

#Software: Microsoft Log Parser
#Version: 1.0
#Date: 2015-02-04 20:05:05
#Fields: RemoteHostReturnCode data hits
421 421 4.7.0 [TS01] Messages from zz.zz.zzz.z temporarily deferred due to user complaints - 4.16.55.1; see http://postmaster.yahoo.com/421-ts01.html 29460
550 550 Requested action not taken: mailbox unavailable 2734
451 451 Temporary local problem - please try later 1970
452 452-4.2.2 The email account that you tried to reach is over quota. Please direct 1655
452 452-4.2.2 the recipient to 1655
421 421-4.7.0 unsolicited mail originating from your IP address. To protect our 1103
421 421-4.7.0 rate limited. Please visit 1103
421 421-4.7.0 http://www.google.com/mail/help/bulk_mail.html to review our Bulk 1103
421 421-4.7.0 users from spam, mail sent from your IP address has been temporarily 1103
450 450 4.7.1 <SERV025.our.network.mydomain.com>: Helo command rejected: Host not found 921
Press a key...


This script is run automatically once a week vi task manager.

But it stops on "Press a key"   I have to Kill the Process in order for it to end.

It ran ok for about two weeks now it has not

It reads the SMTP SEND log file  

A bad record?

Anyway in logparser to bypass this?
0
Comment
Question by:Thomas Grassi
2 Comments
 
LVL 24

Accepted Solution

by:
NVIT earned 500 total points
ID: 40591847
Try adding the -q:ON and / or -iw:ON switches. See the LogParser help for Global Switches:
@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 D:\Progra~1\Microsoft\Exchan~1\V14\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" -q:ON -iw:ON -i:CSV -nSkipLines:4 -o:w3c >c:\util\smtp2.txt

Exit

Open in new window

0
 
LVL 23

Author Closing Comment

by:Thomas Grassi
ID: 40592700
Added both

Ran successfully

Thanks for the help.
0

Featured Post

How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article lists the top 5 free OST to PST Converter Tools. These tools save a lot of time for users when they want to convert OST to PST after their exchange server is no longer available or some other critical issue with exchange server or impor…
Read this checklist to learn more about the 15 things you should never include in an email signature.
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question