Log Parser Plus example query

Requests by file type (extension).

Returns a listing of file types and the total number of requests.
Keywords:
  • iisw3c
Statement:
logparser -rtp:-1 "SELECT EXTRACT_EXTENSION(cs-uri-stem) AS [File Type], COUNT(*) AS [Requests] INTO FileTypeRequests.txt FROM ex0812*.log GROUP BY [File Type] ORDER BY [Requests] DESC"

View more examples

blog comments powered by Disqus