Log Parser Plus example query

Requests by hour per day

Returns a listing of requests by hour, per day, converted to local time.
  • iisw3c
logparser -rtp:-1 "SELECT TO_LOCALTIME(QUANTIZE(TO_TIMESTAMP(date, time), 3600)) AS [DateTime], COUNT(*) AS [Requests] INTO HourlyDayReport.txt FROM ex0902*.log GROUP BY [DateTime] ORDER BY [DateTime]"
Leave a comment on this query.

View more examples.

blog comments powered by Disqus