Log Parser Plus example query

Requests per day

Returns a listing of dates with the total number of requests.
  • iisw3c
logparser -rtp:-1 "SELECT TO_STRING(TO_LOCALTIME(TO_TIMESTAMP(date, time)), 'yyyy-MM-dd') AS [Day], COUNT(*) AS [Requests] INTO DayReport.txt FROM ex1003*.log GROUP BY [Day] ORDER BY [Day]"
Leave a comment on this query.

View more examples.

blog comments powered by Disqus