Log Parser script: Percent of status codes across all hits/requests
Note: This article was written using Log Parser 2.2. Therefore, while it may work for a different version, it may not.
The following SQL can be used by Log Parser to generate a chart with the total requests (for a day, month, or year) and what percent each status code is of those requests. An example chart can be found at the end of this article.
First, I assume that the below is put in the same directory as the logs you would like to parse.
SELECT sc-status AS [HTTP Status Code], count() AS Requests
GROUP BY [HTTP Status Code]
ORDER BY Requests DESC
Once you've saved this, you can call the script like such, so long as you're already in the directory you saved the SQL file.
logparser file:http_status_percent_graph.sql?date=0710 -o:chart -chartType:Pie -chartTitle:"Status as Percent of Requests"
If you just want the numbers, you can use the following SQL.
SELECT sc-status, count()
GROUP BY sc-status
ORDER BY sc-status
It too can be called via the command line (again, assuming you save the SQL file and run the following in the same directory as your log files).
logparser -rtp:-1 file:http_status_codes.sql?date=0710
Feel free to modify the scripts to your own need.
Example of the status code chart
- Review: Empires of EVE: A History of the Great Wars of EVE Online
- Review: Ghost in the Shell README: 1995-2017
- Review: Fitbit Charge 2 Bands,Fitbit Bands Milanese Loop Stainless Steel Metal Replacement Bracelet Strap, Wristbands Accessories for Charge 2 with Stronger Magnetic Clasp
- Review: Wickedly Prime Organic Roasted Seaweed Snacks, Korean Kalbi
- Review: 5-Minute Dungeon
Support This Site
If my blog was helpful to you, then please consider visiting my Amazon Wishlist.