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.
Statement:Leave a comment on this query.
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"
blog comments powered by Disqus