Query parameters with counts and ips

Log Parser Plus example query

Query parameters with counts and ips

Returns a listing of query parameters passed to pages, along with the number of times IP addresses made those requests.

Keywords:

iisw3c

Statement:

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

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

View more examples.