HTTP status codes and sub-status

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). Leave a comment on this query.

View more examples.