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.
Keywords:
  • iisw3c
Statement:
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).

View more examples

blog comments powered by Disqus