Log Parser Plus example query

Requests, bandwidth, and last visit, by IP address and user agent.

Returns a listing of rquests, bandwidth, and last visit, by unique IP address and user agent.
Keywords:
  • iisw3c
Statement:
logparser -rtp:-1 "SELECT COUNT(*) AS [Requests], DIV(DIV(SUM(cs-bytes), 1024), 1024) AS [MBytes received], DIV(DIV(SUM(sc-bytes), 1024), 1024) AS [MBytes sent], c-ip AS [IP Address], cs(User-Agent) AS [User agent], MAX(date) AS [Last visit] INTO IpAddress.txt FROM ex0811*.log GROUP BY [IP Address], [User agent] ORDER BY [Requests] DESC"
Leave a comment on this query.

View more examples.


blog comments powered by Disqus