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"

View more examples

blog comments powered by Disqus