Menu
Home
People
Places
Arts
History
Plants & Animals
Science
Life & Culture
Technology
Reference.org
logparser
open-in-new
<p>logparser is a flexible <a href="/facts/Command_line_interface/R9JpGmXQ">command line</a> utility that was initially written by Gabriele Giuseppini, a <a href="/facts/Microsoft/nGIDDXdx">Microsoft</a> employee, to automate tests for <a href="/facts/Internet_Information_Services/nqmfJr3T">IIS</a> <a href="/facts/Data_logging/U3GglNdc">logging</a>. It was intended for use with the <a href="/facts/Microsoft_Windows/bwhAhuSL">Windows</a> operating system, and was included with the IIS 6.0 <a href="/facts/Resource_Kit/ypdhwzeQ">Resource Kit Tools</a>. The default behavior of logparser works like a "data processing pipeline", by taking an <a href="/facts/SQL/UjQLJcYm">SQL</a> expression on the command line, and outputting the lines containing matches for the SQL expression. </p><p>Microsoft describes Logparser as a powerful, versatile tool that provides universal query access to text-based data such as log files, <a href="/facts/XML/clNgUfWk">XML</a> files and <a href="/facts/Comma-separated_values/dv1pSR1r">CSV</a> files, as well as key data sources on the <a href="/facts/Microsoft_Windows/bwhAhuSL">Windows</a> operating system such as the <a href="/facts/Event_Viewer/YkmF3hrP">Event Log</a>, the <a href="/facts/Windows_Registry/cH9RlHTp">Registry</a>, the file system, and <a href="/facts/Active_Directory/VWd9HhjU">Active Directory</a>. The results of the input query can be custom-formatted in text based output, or they can be persisted to more specialty targets like <a href="/facts/SQL/UjQLJcYm">SQL</a>, <a href="/facts/Syslog/n6a7vIkt">SYSLOG</a>, or a <a href="/facts/Chart/2xshvBX0">chart</a>. </p><p>Common use: </p> > logparser <options> <SQL expression> <p>Example: Selecting date, time and client username accessing <a href="/facts/ASPX/xq7KM8mN">ASPX</a>-files, taken from all <a href="/facts/.log/p7FHf8mA">.log</a>-files in the current directory. </p> > logparser -i:IISW3C -q "SELECT date, time, cs-username FROM *.log WHERE cs-uri-stem LIKE '%.aspx' ORDER BY date, time;"