in

ASP.NET Weblogs

Dan Bright's .NET Weblog

Log Parser Tool 2.0

Microsoft has released a cool little utility for searching log files.

The Log Parser 2.0 tool lets you run SQL-like queries on log files of almost any format, and then display the results in a file format of your choice, in a SQL database, or on a screen. Log Parser is available as a command-line tool and as a set of scriptable Component Object Model (COM) objects.

You can use Log Parser to:

  • Quickly search for data and patterns in log files.
  • Create a variety of reports.
  • Export data to a SQL database.
  • Convert data between different file formats.

Log Parser supports the following input formats:

  • IISW3C: Internet Information Services (IIS) W3C Extended format.
  • IIS: IIS-formatted and IIS-generated log files.
  • IISMSID: Generated when the MSIDFILT filter or the CLOGFILT filter is installed.
  • ODBC: IIS Open Database Connectivity (ODBC) format that reads data directly from the SQL table populated by IIS when the Web server is configured to log to an ODBC target.
  • NCSA: National Center for Supercomputing Applications (NCSA) format.
  • BIN: Binary file format that is generated by IIS 6.0. Contains the requests received by the virtual Web sites on the same server running IIS 6.0.
  • URLSCAN: Generated by the URLScan filter if it is installed on IIS.
  • HTTPERR: IIS 6.0 HTTP error log files format.
  • W3C: W3C log file format, such as for personal firewall, Windows Media Services, and Exchange tracking logs.
  • EVT: Event messaging format from the Windows Event log, including system, application, security, and custom event logs, as well as from event log backup files.
  • FS: File information from the specified path, such as file size, creation time, and file attributes. It is similar to an advanced dir command.
  • CSV: Generic comma-separated value format.
  • TEXTWORD: Generic text format.
  • TEXTLINE: Generic text format.
Published Mar 18 2003, 01:43 AM by DanB

Comments

 

Mike Gunderloy said:

Allow me to mention the Log Parser 2.0 FAQ I've put together - http://www.larkware.com/Articles/LogParser2.0Help.html - it's a solid tool but there are some pretty rough edges.
March 18, 2003 5:27 AM
 

TrackBack said:

Log Parser is a tool available from Microsoft that allows you to run SQL queries against log files and send the information to a SQL Database or other file formats. In this article I describe the capabilities of Log Parser and how you can use it as a set of COM interfaces from your application.
January 11, 2004 11:16 PM
 

Jim Ley said:

I am looking for some sample script to use Log Parser with Visual Basic 2003
January 23, 2004 12:25 PM

Leave a Comment

(required)  
(optional)
(required)  
Add
Terms of Use