Log Parser Plus example query

Requests by seconds to process

Number of requests that took how x seconds to process, rounded up to the nearest second.
Keywords:
  • iisw3c
Statement: 
logparser -i:iisw3c -o:csv "SELECT ADD(DIV(QUANTIZE(time-taken, 1000), 1000), 1) AS [Seconds], COUNT(*) AS [Requests] INTO RequestProcessingTimes.csv FROM ex0906*.log GROUP BY [Seconds] ORDER BY [Seconds] DESC"
Leave a comment on this query.

View more examples.


blog comments powered by Disqus