Count of directory of files requested

Log Parser Plus example query

Count of directory of files requested

Returns a count of the parent directory of all file requests.

Keywords:

iisw3c

Statement:

logparser -i:w3c "SELECT COUNT(*) AS [Requests], EXTRACT_PATH(cs-uri-stem) AS [Path Requested] INTO PathCounts.txt FROM *ex1208*.log GROUP BY [Path Requested] ORDER BY [Requests] DESC"

Notes: Can be useful to determine if any directories can be removed, and if sorted ascending instead, possible exploit attempts. Leave a comment on this query.

View more examples.