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
- --c:\inetpub\slowpage.sql
- Select Top
- Logrow as [line number],
- date as [Date],
- time as [time],
- C-ip as [Client-ip],
- S-ip as [Server IP],
- S-port as [Server Port],
- Cs-method as [Request Verb],
- Cs-uri-stem as [Request URI],
- Sc-bytes as [bytes sent],
- Sc-status as [status],
- Sc-substatus as [sub-status],
- Sc-win32-status as [Win + status],
- Time-taken as [timetaken]
- From
- C:\inetpub\logs\logfiles\w3svc2\u_ex*.log
- Order by time-taken desc
Open the LogParser 2.2 command-line tool and execute the script:
[SQL]View PlainCopy
- 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