Label Cloud

Tuesday, May 29, 2007


I just added an essential tool to my toolset. Microsoft LogParser. This great tool allows running of SQL queries against a variety of log files and other data sources. Here's an example query


SELECT date, REVERSEDNS(c-ip) AS Client, COUNT(*) FROM IISLOG.log WHERE sc-status<>200 GROUP BY date, Client

The same can be ran against event logs, registry, csv, xml files, and much much more.

The link to Microsoft download site is:

There is also a great helper site: with a large collection of scripts to help with the more complicated admin tasks.


No comments:

Directory of Computers/Tech Blogs