Log Parser 2.2 + log Parser lizard GUI parsing IIS Log Example

Log Parser logs analysis tool, with command-line operation, can parse IIS logs,event logs,active directory,log4net,file system,t-sql

Log Parser Lizard operates in a visual interface, using SQL-like syntax queries

：

Log Parser 2.2:
http://www.microsoft.com/en-us/download/details.aspx?id=24659


Log Parser Lizard GUI:
Http://www.lizard-labs.com/log_parser_lizard_buy.aspx

or two packaged resources to download:

Logparser2.2+logparserlizard

After the installation is complete:

LogParser Query Method:

Write SQL script saved as: Slowpage.sql

[SQL]View PlainCopy 

2. --c:\inetpub\slowpage.sql
4. Select Top
6. Logrow as [line number],
8. date as [Date],
10. time as [time],
12. C-ip as [Client-ip],
14. S-ip as [Server IP],
16. S-port as [Server Port],
18. Cs-method as [Request Verb],
20. Cs-uri-stem as [Request URI],
22. Sc-bytes as [bytes sent],
24. Sc-status as [status],
26. Sc-substatus as [sub-status],
28. Sc-win32-status as [Win + status],
30. Time-taken as [timetaken]
32. From
34. C:\inetpub\logs\logfiles\w3svc2\u_ex*.log
36. Order by time-taken desc

Open the LogParser 2.2 command-line tool and execute the script:

[SQL]View PlainCopy 

1. LOGPARSER-I:IISW3C file:c:\inetpub\slowpage.sql-o:datagrid-q:off

Log Parser Lizard Query method:

Open the Log Parser Lizard visual interface, for example, copy the SQL command into the Query window and click Generate [Generate].

can also be displayed in a variety of graphical way, more convenient, intuitive understanding of the analysis:

There are many SQL statements in the log Parser 2.2 installation path:

If you do not know the column name, you can query all the columns first, and then select the useful columns for analysis:

For more use, you can refer to the Help documentation for a number of examples:

Log Parser 2.2 + log Parser lizard GUI parsing IIS Log Example