Log Parser Fundamentals

Learn how to use Log Parser to write queries against many different input formats.
Course info
Rating
(45)
Level
Intermediate
Updated
Aug 8, 2013
Duration
3h 43m
Table of contents
Introduction
Input Formats
Output Formats
IIS Input Format
Event Log Input Format
Miscellaneous
Description
Course info
Rating
(45)
Level
Intermediate
Updated
Aug 8, 2013
Duration
3h 43m
Description

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!

About the author
About the author

Robert is a Microsoft MVP, a Progress Developer Expert (Fiddler), and a 3rd degree black belt in Tae Kwon Do. He regularly speaks at national and international events.

More from the author
Responsive Web Images
Beginner
1h 55m
Jun 27, 2016
Useful jQuery Plugins
Intermediate
3h 6m
Jan 17, 2014
More courses by Robert Boedigheimer
Section Introduction Transcripts
Section Introduction Transcripts

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.