Average Response Time Per Hour Script
Log parser is a powerful, versatile tool that provides universal query access to text-based data such as log files, XML files and CSV files, as well as key data sources on the Windows® operating system such as the Event Log, the Registry, the file system, and Active Directory®. You tell Log Parser what information you need and how you want it processed. The results of your query can be custom-formatted in text based output, or they can be persisted to more specialty targets like SQL, SYSLOG, or a chart. Most software is designed to accomplish a limited number of specific tasks. Log Parser is different... the number of ways it can be used is limited only by the needs and imagination of the user. The world is your database with Log Parser.
SELECT
cs-method AS Method,
sc-status AS Status,
To_Lowercase(cs-uri-stem) AS Page,
cs-uri-query AS Querystring,
Avg(sc-bytes) as ByteSent,
AVG(cs-bytes) as ByteReceived,
COUNT(*) AS Hits
INTO IISLOG_ANALYSIS_NetworkAnalysis.csv
FROM ex*.log
GROUP BY cs-uri-stem, cs-uri-query, cs-method, sc-status
ORDER by ByteSent DESC
cs-method AS Method,
sc-status AS Status,
To_Lowercase(cs-uri-stem) AS Page,
cs-uri-query AS Querystring,
Avg(sc-bytes) as ByteSent,
AVG(cs-bytes) as ByteReceived,
COUNT(*) AS Hits
INTO IISLOG_ANALYSIS_NetworkAnalysis.csv
FROM ex*.log
GROUP BY cs-uri-stem, cs-uri-query, cs-method, sc-status
ORDER by ByteSent DESC