Parsing IIS logs with log Parser Studio

Discover a powerful graphical IIS log analysis tool--log Parser Studio, below to share a practical case.

1. Install log Parser Studio

A) You need to install log parser,:http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=24659 first

b) Install Log Parser studio,:http://gallery.technet.microsoft.com/log-parser-studio-cd458765 and unzip it after downloading.

2. Run Log Parser Studio

Run LPS.exe in the previously unzipped Lpsv2.d1 folder.

3. Specify the IIS log file path

4. Create a query

A) Click on the "Create a new Queyr" button

b) Enter query statements (SQL syntax) in the query window, such as:

SELECT TOP cs-uri-stem,time-taken,to_timestamp (date, time) as Timestampfrom ' [LogFilePath] ' WHERE time-taken > 2000

c) Set the log Type, for example, Iisw3clog is used here.

5. Execute the query

A) Click on the "Execute Active query" button

b) The results of the implementation are as follows:

It's really convenient!

Resources

Introducing:log Parser Studio

Parsing IIS logs with log Parser Studio