Log Parser Plus example query

HTTP status codes and percentage of total

Returns a listing of HTTP status codes with counts and percentage per.
Keywords:
  • iisw3c
Statement: 
logparser -rtp:-1 "SELECT sc-status, COUNT(*) AS [Requests], MUL(PROPCOUNT(*), 100) AS [Percentage] FROM ex0902*.log GROUP BY sc-status"
Leave a comment on this query.

View more examples.


blog comments powered by Disqus