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

Log Parser Plus example query

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

Returns a listing of requests, 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"