Log Parser is a free tool from Microsoft that provides the ability to write SQL-like queries against a large number of input formats. It is not just text based files like web logs, CSV files, etc. but also system resources like the file system, registry and event logs. Learn some best practices for monitoring your systems with log parser!
Introduction Hi, welcome to this Pluralsight course on Log Parser Fundamentals. In this module, we're going to first look at what is Log Parser, we're going to review a brief history, we're going to see where you can get it, we're going to look at the command line arguments that are available, we're going to review the SQL-like Query Syntax, we're going to look at the aggregate functions that are available within that SQL query, and finally we'll look at the remainder of the built-in functions available within the SQL language.
Input Formats In this module, we're going to look at the input formats that are supported natively by Log Parser. The first two, IIS Logs and Event Logs, we have individual modules for these later, so we'll not focus on them now. We can also look at the File System, so we can actually use Log Parser to make queries about files and directories on our machine. We can also look at the Registry, comma-delimited and tab-delimited files. We can also use it to parse XML files. And then there's a series of other input formats that I want to make you aware of that we're not going to go in detail in this course.
Output Formats In this module we're going to look at the output formats that are available for Log Parser. One is comma-separated values, another is a DATAGRID, which is just a popup window where you can see individual records, the CHART control, which is very interesting, lets you create pie graphs, line charts, things like that based on your output data, templates are available, if you need to output in a certain format that's not supported, you can create a template file that the output will be applied against to create the actual generated desired files, XML, and a variety of other output formats.
IIS Input Format In this module we're going to look at what originally got me interested in Log Parser, which was the ability to look at IIS Log Files. We're first going to look at the particular IIS Log File Format options. We're then going to focus on the W3C Extended Format and look at some of the fields that we can use. We're going to look at ASP. NET's ability to AppendToLog, which will allow me to place specific information into an IIS log entry, and we're also going to look at recommended practices for analyzing IIS Logs.
Event Log Input Format The other major area besides IIS logs where I use Log Parser extensively is to analyze Event Logs. So in this module we're going to look at the Event Logs that are present in Windows. We're going to look at the Event Log Fields that are available for Log Parser queries. We're going to look at the Event Log parameters for Log Parser. We're then going to focus on an ASP. NET Event Strategy and we're going to look at some common queries that are useful for looking at information in the Event Logs.
Miscellaneous In this module we'll look at some miscellaneous uses for Log Parser. The first will be using LogParser. dll from other programs, in this case, we'll demonstrate how to call it from. NET, we'll see how you can create multiple output files from a single run using the multiplex feature, and then we're going to look at two GUIs that make using Log Parser easier. The first is Log Parser Lizard and the second is Log Parser Studio.