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

Source: Internet
Author: User

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 
  1. --c:\inetpub\slowpage.sql
  2. Select Top
  3. Logrow as [line number],
  4. date as [Date],
  5. time as [time],
  6. C-ip as [Client-ip],
  7. S-ip as [Server IP],
  8. S-port as [Server Port],
  9. Cs-method as [Request Verb],
  10. Cs-uri-stem as [Request URI],
  11. Sc-bytes as [bytes sent],
  12. Sc-status as [status],
  13. Sc-substatus as [sub-status],
  14. Sc-win32-status as [Win + status],
  15. Time-taken as [timetaken]
  16. From
  17. C:\inetpub\logs\logfiles\w3svc2\u_ex*.log
  18. 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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.