Log Parser Plus example query

Count of directory of files requested

Returns a count of the parent directory of all file requests.
  • iisw3c
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.

blog comments powered by Disqus