Log Parser Plus example query

HTTP status codes and sub-status

Returns a listing of status and sub-status codes, with number of requests returning each.
  • iisw3c
logparser -i:iis "SELECT STRCAT(TO_STRING(sc-status), STRCAT('.', TO_STRING(sc-substatus))) AS Status, Count(*) as Hits INTO StatusCodes.txt FROM *ex1107*.log GROUP BY Status ORDER BY Hits DESC"
Notes: Query written and provided by Chevis L. Nelson (drcheeves [at] yahoo.com). Leave a comment on this query.

View more examples.

blog comments powered by Disqus