Log Parser Plus example query

Requests by hour (using TO_TIME)

Returns a listing of requests by hour, across all days, converted to local time.
Keywords:
  • iisw3c
Statement: 
logparser -rtp:-1 "SELECT TO_TIME(TO_LOCALTIME(QUANTIZE(TO_TIMESTAMP(date, time), 3600))) AS [Hour], COUNT(*) AS [Requests], MUL(PROPCOUNT(*), 100) AS [PercentOfTotal] INTO HourlyReport.txt FROM ex0902*.log GROUP BY [Hour] ORDER BY [Hour]"
Leave a comment on this query.

View more examples.


blog comments powered by Disqus