logparser
logparser | |
---|---|
![]() | |
Stable release | 2.2.10
/ 2005-04-20 |
Operating system | Windows 2000; Windows Server 2003; Windows XP |
Type | Tool |
License | Free |
Website | http://www.logparser.com/ |
logparser is a flexible command line utility that was initially written by Gabriele Giuseppini[citation needed], a Microsoft employee, to automate tests for IIS logging. It was intended for use with the Windows operating system, and was included with the IIS 6.0 [[Resource Kit|Resource Kit Tools]. The default behavior of logparser works like a "data processing pipeline", by taking an SQL expression on the command line, and outputting the lines containing matches for the SQL expression.
Microsoft describes Logparser as a powerful, versatile tool that provides universal query access to text-based data such as log files, XML files and CSV files, as well as key data sources on the Windows operating system such as the Event Log, the Registry, the file system, and Active Directory. The results of the input query can be custom-formatted in text based output, or they can be persisted to more specialty targets like SQL, SYSLOG, or a chart.
Common use:
$ logparser <options> <SQL expression>
Example: Selecting date, time and client username accessing ASPX-files, taken from all .log-files in the current directory.
$ logparser -e:IISW3C -q "SELECT date, time, cs-username FROM *.log WHERE cs-uri-stem LIKE '%.aspx' ORDER BY date, time;"
External links
(www.logparser.com now redirects to www.iis.net)
- Logparser site - The Central hub of all things Logparser
- Logparser Forums - the Logparser forums
- Logparser example repository - the examples
- Microsoft Script Center page - The Microsoft logparser overview page
- Professor Windows - May 2005 - How Log Parser 2.2 Works by Gabriele Giuseppini
- Examples (SQL) queries for IIS Analysis
- Under the hood of Logparser by Jeff Atwood
- Visual Log Parser GUI for Logparser
- Log Parser Lizard GUI for Logparser
- Microsoft Log Parser Toolkit Book on LogParser, by Gabriele Giuseppini and Mark Burnett