Query parameters with counts

Log Parser Plus example query

Query parameters with counts

Returns a listing of query parameters passed to pages, with the number of times such requests were made. Helpful to get an idea on whether any hacking attempts were being made.

Keywords:

iisw3c

Statement:

logparser -rtp:-1 -o:w3c "SELECT cs-uri-query, COUNT(*) AS [Requests] INTO QueryParams-1b.log FROM ex0910*.log WHERE cs-uri-query IS NOT null GROUP BY cs-uri-query ORDER BY cs-uri-query"

Notes: See also Query parameters with counts and ips. Leave a comment on this query.

View more examples.