Logparser Scenario 9:Find out what is the peak time for your IIS Server

This blog entry is a continuation of the KB Article http://support.microsoft.com/?id=910447 Scenario 9: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,…

3

Logparser Scenario 8:Checking the traffic/requests between a specific client and server

This blog entry is a continuation of the KB Article http://support.microsoft.com/?id=910447. Scenario 8: 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!…

1

Logparser Scenario 7:Searching specific column names from a CSV file

This blog entry is a continuation of the KB Article http://support.microsoft.com/?id=910447. Scenario 7: Searching specific column data from a CSV file using Logparser Let’s say you have a CSV (comma separated value) text file as follows… abc,abd,ac,rd,abe,f,g1,2,3,4,5,6,73,2,3,4,5,2,53,4,5,7,3,5,7 And then, you want the columns with the following names… (abc, abd and abe) so that you can…


Logparser Scenario 6:Searching files for culprits when you don’t have Visual Studio on the Server.

This blog entry is a continuation of the KB Article http://support.microsoft.com/?id=910447. 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 website were seeing other user’s data in ASP.NET. There is cool blog entry about it…

5

What could be a more reliable way to find out "A word or phrase in the file"?

Well, I don’t trust A word or phrase in the file search in Windows XP. And sure it needs improvement! Sometimes, it gives you results, but most of the times it doesn’t :o( Here is what you can do to prove the point which I want to make. 1. Go to your desktop and create…

13

Logparser Scenario 5:Analyzing the IISlogs to see if there is any pattern for errors

This blog entry is a continuation of the KB Article http://support.microsoft.com/?id=910447. 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…

1

Log Parser 2.2 and ASP.NET – ASP.NET Support Voice Column released

This is my first article for Microsoft ASP.NET Support Voice Column! I hope you will enjoy it. I am looking for more participation on using the Log parser, so feel free to write to me if you have some cool Logparser queries to share.Log Parser 2.2 and ASP.NEThttp://support.microsoft.com/?id=910447 Cheers,Rahul  

2

What is Log Parser 2.2?

<From the Log Parser 2.2 documentation> 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®. </From…

2