Log Parser Plus example query
Data sent and received, by file type.
Returns a listing of file types, as well as the amount of data sent and received by the server, for each request.
Statement:Leave a comment on this query.
logparser -rtp:-1 "SELECT EXTRACT_EXTENSION(cs-uri-stem) AS [File Type], DIV(SUM(sc-bytes), 1024) AS [Sent (KB)], DIV(SUM(cs-bytes), 1024) AS [Received (KB)] INTO FileTypeDataSentRec.txt FROM ex0812*.log GROUP BY [File Type] ORDER BY [File Type]"
blog comments powered by Disqus