Log Parser 2.2 Released!

Finally, Log Parser 2.2 has been released. If you didn”t know, LogParser is a great little tool that will rip through log files & delimited data files (Event logs, IIS logs, CSV, etc) & allow you to execute SQL-like queries against the data. It even has a COM interface.

The new version, 2.2, supports some new data types & SQL commands, and also will generate graphs based on query results, e.g. to calculate the distribution of the HTTP best online casino response status codes from your IIS log files: 

C:>LogParser "SELECT sc-status, COUNT(*) AS Times INTO Chart.gif 
FROM ex*.log GROUP BY sc-status ORDER BY Times DESC" –
chartType:PieExploded3D -chartTitle:"Status Codes"

generates this

The above example is from the logparser examples page.

So, if you have a bunch of log files & want to run some easy queries against it, check out logparser.

0

Written by Ben Strackany -- February 7, 2005

Ben worked for a variety of tech startups in Chicago before moving to Portland and starting DevelopmentNow in 2005. When he's not herding cats, stirring pots, and taking names, he enjoys drinking coffee while irritating the studio audience with bad puns.