Log Parser Plus example query

Requests by hour per day

Returns a listing of requests by hour, per day, converted to local time.
Keywords:
  • iisw3c
Statement:
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]"

View more examples

blog comments powered by Disqus