Project 02 : IIS Log Analyzer BobBacus.com

Main  |   Research  |   Photos  |   Projects  |   Email  |   RSS

IIS Log Analyzer This is a .NET 2.0 Windows graphical interface to the Log Parser 2.2 tool from Microsoft. This tool allows you to perform data analysis on IIS web log files. You can find more information on use of the Log Parser tool at http://www.logparser.com/. This application provides an interface similar to SQL Query Analyzer in that you enter SQL-style query statements and highlight the query you want to run, then execute the query. The results are displayed in a data table. New in Log Parser 2.2 is the ability to generate charts similar to Excel. IIS Log Analyzer provides a simple interface to generate a chart of the results table using Log Parser.

Verion History

Version 0.1 (Release date 3 Nov 2006)

• Initial release

Version 0.2 (Release date 27 Jan 2008)

• Updated to .NET 2.0 Framework
• Added syntax-highlighting to SQL window
• Integrated chart generation interface into main window
• Added tabbed DataGrid display for showing multiple queries
• Removed field list; replaced with popup field list (activated by alt-z)
• Added popup function list (activated by alt-x)
• Added link in app to this page

Prerequisites

The IIS Log Analyzer interface can be downloaded below. It is dependent on the following; download and install these packages if you do not already have them, they are not included with the IIS Log Analyzer application:

• Microsoft .NET 2.0 Framework
• Log Parser 2.2

Error Messages

COM object with CLSID {8CFEBA94-3FC2-45CA-B9A5-9EDACF704F66} is either not valid or not registered.

LogParser.dll is not registered as a COM component; run the command regsvr32.exe LogParser.dll in the directory where Log Parser is installed (usually C:\Program Files\Log Parser 2.2\) to register the dll.

Unspecified error
   at IISAnalyzer.Chart.btnBuildChart_Click(Object sender, EventArgs e)

Incorrect version of LogParser.dll is registered. Register LogParser.dll from version 2.2.

Error creating output format "CHART": This output format requires a licensed Microsoft Office Chart Web Component to be
installed on the local machine [Not enough resources are available to process this command.]

   at MSUtil.COMChartOutputContextClass.set_categories(String pszcategories)
   at IISAnalyzer.Chart.btnBuildChart_Click(Object sender, EventArgs e)

To create charts, the Microsoft Office 2003 Web Components must be installed. If this is not installed on your system, chart generation capability will not be available.

Bug Reports / Feature Requests

Please send any bug reports or new feature requests via email.

Download

This software is released as Freeware.
Download IIS Log Analyzer here:
Version 0.2: IISLogAnalyzer02.zip (.NET 2.0)
Version 0.1: IISLogAnalyzer01.zip (.NET 1.1)

©1996-2010 Bob Bacus