Log Parser Lizard

Recently I’ve been working a bit with Log Parser Lizard and it’s been very helpful.

You can take log files, import them, pick the expected format, and then query them in a SQL style manner.

So for example, I took a bunch of IIS log files and was able to easily run this query against it:

SELECT *
FROM 'C:\Users\Chris\Downloads\www-logs\*.log'
where sc-status = 404 and cs-uri-stem <> '/AzureFileHandler.ashx'
and cs-uri-stem <> '/js/jquery.1.11.1.min.js'

 

Pretty cool

image

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s