LogParser 2.2 is out. If you are any kind of admin and you haven't tried this tool, your are really missing out!
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®. You tell Log Parser what information you need and how you want it processed. The results of your query can be custom-formatted in text based output, or they can be persisted to more specialty targets like SQL, SYSLOG, or a chart.
It looks like there is a lot of work going on with this tools since there are really a lot of new features and other improvements in 2.2. Also, there is a growing community of fans.
I didn't yet master the tool but this is the first LogParser query that I wrote:
SELECT REVERSEDNS(c-ip) AS Client, c-ip, COUNT(*) AS Requests
WHERE Index_OF(cs(User-Agent), 'Mozilla') < 0 AND
cs-uri-stem = '/weblog/rss.aspx'
GROUP BY c-ip, cs(User-Agent)
It will return a list of IPs and addresses with the number of request for a RSS feed in 2005.
And that's what we all wan't to know, right? Who the hell is reading my blog!?