Log Parser Plus example query

Number of errors by half hour

Returns the total number of errors, broken into 30 minute blocks.
Keywords:
  • iisw3c
Statement: 
logparser -i:iis "SELECT TO_LOCALTIME(QUANTIZE(time, 1800)) as HalfHour, COUNT(*) as Hits INTO ErrorCount.txt FROM *ex1107*.log WHERE sc-status > 399 GROUP BY HalfHour ORDER BY HalfHour ASC"
Notes: Query written and provided by Chevis L. Nelson (drcheeves [at] yahoo.com). Leave a comment on this query.

View more examples.


blog comments powered by Disqus