Using Log Parser for analyzing IIS Logs

Microsoft Log Parser is a Command Line tool to analyze and extract data from all sorts of Log Files. It is a command line tool and does not have a fancy UI but is extremely power. The most powerful feature is the use of SQL Like query structure to extract information.

Just created the following Availability Throughput report for a couple of application that we have here. It is taking the average of the time-taken field in the IIS log over the last 4 months.

See the Log parser query.

After getting the data it is just a matter of putting it in an excel and generting the graph which I did but the Log Parser tool itself can generate a graph output as an image. There is along list of input and output formats for the tool. I just did’nt had time to look into the graph switches right now.

 

Advertisements

2 thoughts on “Using Log Parser for analyzing IIS Logs

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s