Log Parser Plus example query

HTTP Status Codes (pie chart)

Returns a pie chart showing what percentage status codes account for. Requires Microsoft Office.
  • iisw3c
logparser -o:chart -chartType:Pie -chartTitle:"Status as Percent of Requests" "SELECT sc-status AS [HTTP Status Code], COUNT(*) AS Requests INTO HttpStatusCodePieChart.png FROM ex0811*.log GROUP BY [HTTP Status Code] ORDER BY Requests DESC"
Notes: Microsoft Office must be installed to generate the chart. Example output available at <a href="http://strivinglife.com/words/post/Log-Parser-script-Percent-of-status-codes-across-all-hitsrequests.aspx">StrivingLife.com</a>. Leave a comment on this query.

View more examples.

blog comments powered by Disqus