July 2014 archive

IIS log parser

Typically information about every request that hits IIS will be written to the iis logs. For busy sites the amount of information being logged will mean these log files aren’t very readable by simply scanning the files. There is an MS tool for parsing these files: http://www.iis.net/downloads/community/2010/04/log-parser-22
It allows you to concoct sql like queries which then can run over a set of log files.

To run logparser, fire up a command prompt and run:

Then some examples of the specific sql files:
Number of hits per hour:

Which pages have been requested in the last N days

How many times has a specific page been requested by specific IP’s?
Note, you can filter out by ip if needs be

1 2