This post is a continuation of this article. Scenario 9:Find out total count of different errors in your HTTP Error Log file on any IIS Server Answer: Logparser "select sc-status, s-reason, cs-uri, count(*) from 'FolderName\*.log' to 'FolderName\Total.csv' Group by s-reason, sc-status, cs-uri" -o:CSV -i:HTTPERR If you want to just see the different types of errors coming up… use the following… Logparser "select s-reason, count(*) from 'FolderName\*.log' to 'FolderName\Total.c... [More]

This post is a continuation of this article. Scenario 8:Find out what is the peak time for your IIS Server How can you find out what is the peak time (peak hour) for your Website using Logparser? Answer: Logparser "SELECT quantize(time,60), count(*) as Frequency from ex080716.log GROUP BY quantize(time,60) order by quantize(time, 60)" -rtp:-1 Here is a brief snapshot of my LogFile... And here is the output... QUANTIZE(time, 60) Frequency ------------------ --------- 02:37:00   &n... [More]

This post is a continuation of this article. Scenario 7: Checking the traffic/requests between a specific client and server Why would you do it in the first place? You may want to troubleshoot an authenticate issue for that specific client for the error that s/he reported to you. May be that's why! Answer: Logparser "select date, time, c-ip, cs-username, s-sitename, s-computername, s-ip, s-port, cs-method, cs-uri-stem, cs-uri-query, sc-status, sc-substatus,sc-win32-status, sc-bytes, cs-bytes, ti... [More]

This post is a continuation of this article. Scenario 6: Searching for any specific text in all the files of a folder. A small background of the problemRecently we saw a very interesting problem. Users of a web-site were seeing other user's data in ASP.NET. There is cool blog entry about it by Jerry Orman where he talks about how to go about troubleshooting these issues. The Step 2 in his entry mentions about use of Caching. The customer didn't have much idea about the code (although it was pres... [More]

I have written an article on Log parser a while ago at Log Parser 2.2 and ASP.NET. Please read it before you continue on this post... Here are some of the other scenarios in which you could use it... Scenario 5: Analyzing the IISlogs to see if there is any pattern for errors A small background of the problemYou are using Microsoft Internet Information Services (IIS) 6, have a few Web sites, and you are using COM components in a lot of your webpages. Now, somehow you find that there are quite a ... [More]