Log Parser Plus example query
Requests by hour (using TO_STRING)
Returns a listing of requests by hour, across all days, by converting the hour to a string.
Statement:Leave a comment on this query.
logparser -rtp:-1 "SELECT TO_STRING(time, 'hh') AS [Hour], COUNT(*) AS [Requests], MUL(PROPCOUNT(*), 100) AS [PercentOfTotal] INTO HourlyReport.txt FROM ex0902*.log GROUP BY [Hour] ORDER BY [Hour]"
blog comments powered by Disqus