Skip to content

Instantly share code, notes, and snippets.

@m0veax

m0veax/analysis.md

Last active April 29, 2019 09:16
Show Gist options
  • Save m0veax/266f18af2b488deeb66558d8f23c929d to your computer and use it in GitHub Desktop.
Save m0veax/266f18af2b488deeb66558d8f23c929d to your computer and use it in GitHub Desktop.
Download ZIP
logparser.exe Analysis
Raw
analysis.md

commands for analysis of IIS Logfiles

Average Taken Time for Requests DESC

logparser.exe "SELECT  cs-uri-stem, cs-uri-query, COUNT(*) AS TotalCount, MAX(time-taken) AS MaximumTime, AVG(time-taken) AS AverageTime FROM *.log GROUP BY cs-uri-stem, cs-uri-query ORDER BY AverageTime DESC" -i:w3c

HTTP Status and Time-Taken for cs-uri-stem

take an cs-uri-stem value from the report above and replace it in the following command

logparser.exe "SELECT  cs-uri-stem, cs-uri-query, sc-status, time-taken FROM *.log WHERE (cs-uri-stem='<cs_uri_stem_value>') ORDER BY time-taken DESC" -i:w3c
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment