Microsoft Log Parser 2
Log Parser 2.0 is a versatile tool that you can use to perform many tasks related to log files, including filtering entries, converting log files to other formats, and performing data mining. The tool supports many different input formats, including all of the Internet Information Services (IIS) log file formats, and it supports multiple output formats, including text files and database tables. Log Parser is available as a command-line tool and as a set of COM objects that support scripting.
Log Parser works by running Structured Query Language (SQL)-type queries against source files. The tool can then write the query results to different target files, including text files and database tables, or it can print the results to the screen.
You can use Log Parser to perform many different log-related tasks, including the following:
- Quickly search for data and patterns in files of various formats
- Create formatted reports and XML files containing data retrieved from different sources.
- Export data to SQL tables. You can export entire files or filter the data to obtain only relevant entries.
- Convert data from one log file format to another
Log Parser supports the following input formats:
- IISW3C: This is the IIS W3C Extended log file format.
- IIS: This is the IIS log file format.
- IISMSID: This is the log format for files generated by IIS when the MSIDFILT filter or the CLOGFILT filter is installed.
- NCSA: This is the IIS NCSA Common log file format.
- ODBC: This is the IIS ODBC format, which sends log files to an ODBC-compliant database.
- BIN: This is the IIS binary log file format.
- URLSCAN: This is the format for URLScan logs.
- HTTPERR: This is the IIS 6.0 HTTP error log file format.
- EVT: This is the Microsoft Windows Event Messages format.
- TEXTWORD: This is a generic text file, where the TEXT value is any separate word.
- TEXTLINE: This is a generic text file, where the TEXT value is any separate line.
- CSV: This is a comma-separated list of values.
- W3C: This is a generic W3C log file, such as a log generated by Windows Media Services or Personal Firewall.
- FS: This provides information about file and directory properties.
Log Parser supports the following output formats:
- W3C: This format sends results to a text file that contains headers and values that are separated by spaces.
- IIS: This format sends results to a text file with values separated by commas and spaces.
- SQL: This format sends results to a SQL table.
- CSV: This format sends results to a text file. Values are separated by commas and optional tab spaces.
- XML: This format sends results to an XML-formatted text file.
- Template: This format sends results to a text file formatted according to a user-specified template.
- Native: This format is intended for viewing results on screen.