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.

View more examples

blog comments powered by Disqus