Log Parser Plus example query
Bandwidth usage by request
Returns pages sorted by the total number of bytes transferred, as well as the total number of requests and average bytes.
Statement:Notes: Original query posted to Server Fault by Jeff Atwood and corrected by James Skemp. Leave a comment on this query.
logparser -i:iisw3c -rtp:-1 "SELECT DISTINCT TO_LOWERCASE(cs-uri-stem) AS [Url], COUNT(*) AS [Requests], AVG(sc-bytes) AS [AvgBytes], SUM(sc-bytes) AS [Bytes sent] INTO Bandwidth.txt FROM ex0909*.log GROUP BY [Url] HAVING [Requests] >= 20 ORDER BY [Bytes sent] DESC"
blog comments powered by Disqus