Parsing IIS logs
I never really had to manually parse IIS logs to get some stats until now and I wanted to get some numbers that the installed stats engine didn’t provide. I did a little research and found a tool call LogParser.
I know, I know. Boring. Nothing new. Old news. OK, OK, this free Microsoft tool was available for a while now but this is brand new for me ;-)
LogParser has many cool parts:
You can query various sources like IIS logs, the Event log and the Registry.
It provides a SQL like syntax.
SELECT EXTRACT_EXTENSION(cs-uri-stem) AS PageType, COUNT(*)
FROM ex040528.log
GROUP BY PageType
It comes as a Command line tool and a COM DLL that you can call from a .NET app.
It’s free and you can find tons of content and blog entries to help you get started.
