Jump to content

logparser

From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by Veekay (talk | contribs) at 08:33, 6 January 2011. The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.


logparser
Stable release
2.2.10 / 2005-04-20
Operating systemWindows 2000; Windows Server 2003; Windows XP
TypeTool
LicenseFree
Websitehttp://www.logparser.com/

logparser is a command line utility that was initially written by Gabriele Giuseppini, a then Microsoft employee, to automate tests for IIS logging. It was intended for use with the Windows operating system. The default behavior of logparser takes an SQL expression on the command line, outputs 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. You tell Log Parser what information you need and how you want it processed. The results of your 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;"

(www.logparser.com now redirects to www.iis.net)