Ken Schaefer

PingView by LogParser (Create Graph of Ping Response Time)

Thank for cool ping & logparser solution.
I creat pingview.cmd from your example.

MVP for SQL Server / Japan

Very nifty! I already knew about LogParser, but didn't know that you could even make graphs like this. This way it's almost trivial to generate graphs showing accessibility to your websites over time or availability of internal servers over time.

There is one *very* tiny typo in your code at the end of the REPLACE_STR function: it should be 'ms','')) instead of 'ms',')) otherwise you'll get an error

I too got the output, Error: Syntax Error: <function-expr>: cannot find closing parenthesis for function REPLACE_STR, didnt take me lng to find the typo. Nice use of the tool. Did you know you can also parse webpages with it?

LogParser.exe "SELECT Text FROM http://www.adopenstatic.com/cs/blogs/ken/archive/2005/05/30/22.aspx WHERE Text LIKE '%knowledgeable%' " -i:TEXTLINE

Text
--------------------------------------------------------------------------------
------------------------------------------------------------
Bernard is a very knowledgeable IIS MVP who maintains a blog at <a href="http://
www.msmvps.com/bernard/" title="Bernard's Blog" target="_blank">www.msmvps.com/b
ernard</a>. Aside from the LogParser Toolkit, he co-authored <a href="http://www
.amazon.com/exec/obidos/ASIN/1931836256/adopenstati0f-20" title="CYA Securing II
S 6.0" target="_blank">Securing IIS 6.0</a> (Syngress Press)

Statistics:
-----------
Elements processed: 305
Elements output: 1
Execution time: 0.52 seconds

Thanks for the feedback guys. I've finally got around to fixing the typo in the code :-)

PingBack from http://aggressivevirusdefense.wordpress.com/2010/04/23/log-parser/

PingBack from http://andromedarabbit.net/wp/log_parser/

PingBack from http://x443.wordpress.com/2011/08/10/logparser-2-2-graph-ping/

PingBack from http://www.techish.net/2011/12/graph-ping-time-with-microsoft-logparser/

PingBack from http://andromedarabbit.net/wp/microsoft_log_parser/

PingBack from https://techish.net/2011/graph-ping-time-with-microsoft-logparser/