Log Parser Plus example query

Requests per day

Returns a listing of dates with the total number of requests.
Keywords:
  • iisw3c
Statement: 
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