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"
Leave a comment on this query.

View more examples.


blog comments powered by Disqus