View source for Logparser

{{lowercase|title=Logparser}}

{{Infobox Software
| name = logparser 
| logo = Logparsericon.jpg
| screenshot = Logparser.JPG
| screenshot size = 250px
| caption = 
| author = 
| developer = 
| released = 
| latest release version = 2.2.10
| latest release date = 2005-04-20
| latest preview version = 
| latest preview date = 
| operating system = Windows Server 2003
| platform = 
| language = 
| genre = Tool
| license = Free
| website = 
}}{{Inline citations|date=July 2024}}
'''logparser''' is a flexible [[command line interface|command line]] utility that was initially written by Gabriele Giuseppini,<ref>{{cite web |title=Microsoft Log Parser Toolkit |url=http://www.syngress.com/information-security-and-system-administrators/Microsoft-Log-Parser-Toolkit/ |archive-url=https://web.archive.org/web/20130128053813/http://www.syngress.com/information-security-and-system-administrators/Microsoft-Log-Parser-Toolkit/ |archive-date=2013-01-28}}</ref> a [[Microsoft]] employee, to automate tests for [[Internet Information Services|IIS]] [[Data logging|logging]]. It was intended for use with the [[Microsoft Windows|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 [[Comma-separated values|CSV]] files, as well as key data sources on the [[Microsoft Windows|Windows]] operating system such as the [[Event Viewer|Event Log]], the [[Windows Registry|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|SYSLOG]], or a [[chart]].

'''Common use:'''
{{sxhl|> logparser <options> <SQL expression>|doscon}}

'''Example:''' Selecting date, time and client [[User (computing)|username]] accessing [[ASPX]]-files, taken from all [[.log]]-files in the current directory.
 > logparser -i:IISW3C -q "{{codett|SELECT date, time, cs-username FROM *.log WHERE cs-uri-stem LIKE '%.aspx' ORDER BY date, time;|sql}}"

==References==
{{Reflist}}

==External links==
* [https://www.microsoft.com/en-us/download/details.aspx?id=24659 Microsoft Log Parser 2.2] - the official Microsoft download page.
* [http://www.lizard-labs.net/ Log Parser Lizard] - a GUI for Log Parser
* [http://www.logparser.com/ The Unofficial Log Parser Home Page] - a collection of Log Parser references
* [https://technet.microsoft.com/en-us/library/bb878032.aspx Professor Windows - May 2005 - How Log Parser 2.2 Works] - article by Gabriele Giuseppini (creator of Log Parser)
* [http://linuxlore.blogspot.com/2006/11/howto-use-microsofts-logparser-to.html Examples (SQL) queries for IIS Analysis] - a collection of Log Parser examples
* [http://blog.codinghorror.com/microsoft-logparser/ Under the hood of LogParser] - article Jeff Atwood
* [http://logparserplus.com/ Log Parser Plus] - queries/tutorials to help you analyze logs
* [http://gluegood.blogspot.com/2008/04/freeware-logparseroledb.html Logparser.OLEDB] - a freeware OLEDB input format plugin

===Archived links===
The following links are only available through the [https://web.archive.org/ Internet Archive]:
* [https://web.archive.org/web/20170710212920/http://gallery.technet.microsoft.com/office/Log-Parser-Studio-cd458765 Log Parser Studio] - a GUI Utility for Log Parser
* [https://web.archive.org/web/20180118113035/http://visuallogparser.codeplex.com/ Visual Log Parser] - a GUI for Log Parser
* [https://web.archive.org/web/20220213195030/https://forums.iis.net/default.aspx/51 Log Parser Forums] - while the original, dedicated Log Parser forums are gone, you can still view the contents in the archives or try a [https://learn.microsoft.com/search/?terms=log+parser&category=QnA keyword search] of Microsoft's QnA forums
* [https://web.archive.org/web/20090315165728/http://www.microsoft.com/technet/scriptcenter/tools/logparser/default.mspx Microsoft Log Parser overview page] - informational article on Microsoft's scripting tools website

[[Category:Windows security software]]