How to use Log Parser Studio

How to analyze logs (IIS, Event Viewer etc.) using Log Parser Studio?


Log Parser Studio is a GUI for Microsoft's Log Parser and can be used to better process large amount of logs (for example IIS logs), or exceptionally large files which perform poorly in their native software (Large Event Viewer files).

How to Install

The GUI has to be installed on top of the Log parser using the steps below

  1. Install Log Parser 2.2 from here 

  2. Install Log Parser Studio from here  

How to Use

In a nutshell, Log Parser Studio is a guy that supports building and running SQL queries on log files. The queries can also be exported in various formats like Powershell to execute them locally without having Log Parser Installed.
The following MSDN article contains a lot of useful links for various types of Log Parser Studio queries.