Log Parser Plus example query
Requests by half hour
Total number of requests, broken into 30 minute blocks.
Statement:Notes: Query written and provided by Chevis L. Nelson (drcheeves [at] yahoo.com). Leave a comment on this query.
logparser -i:iis "SELECT TO_LOCALTIME(QUANTIZE(time, 1800)) as HalfHour, COUNT(*) as Hits INTO HalfHourRequestCount.txt FROM *ex1107*.log GROUP BY HalfHour ORDER BY HalfHour ASC"
blog comments powered by Disqus