DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 296093 - Last Review: November 21, 2006 - Revision: 3.2

This article was previously published under Q296093

SUMMARY

Microsoft Knowledge Base article
296085  (http://support.microsoft.com/kb/296085/EN-US/ ) HOWTO: Analyzing Web Logs with SQL
describes a utility that you can use to strip the header lines from an Internet Information Server/Services (IIS) log for bulk insert to Microsoft SQL Server. This article provides that utility as well as the source code.

The Prewebplog.exe utility takes the path and file name of an IIS log file, removes the lines that start with "#" (these are the header lines in Web logs) and outputs the file to STDOUT.

MORE INFORMATION

The following file is available for download from the Microsoft Download Center:
PrepWebLog.exe (http://download.microsoft.com/download/iis50/utility4/1.0/win98mexp/en-us/prepweblog.exe)
Release Date: JUN-21-2001

For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:
119591  (http://support.microsoft.com/kb/119591/EN-US/ ) How to Obtain Microsoft Support Files from Online Services
Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file. The PrepWebLog.exe file contains the following files:

Collapse this tableExpand this table
File nameSize (bytes)
Preplog.opt48,640
Preplog.cpp1,274
Preplog.plg16,779
Preplog.exe45,056
Preplog.obj1,883
Vc60.idb41,984
Preplog.pch3,655,472
Preplog.dsp3,413
Preplog.dsw537
Readme.txt203
To run the utility, use the following command:
D:\>preplog.exe [name of web log]
The output will go automatically go to STDOUT. Add a file name to direct to a specific output file:
D:\>preplog.exe [name of web log] > [name of output file]

For example, to send the output to a file called "C:\Out.log":
D:\>preplog.exe c:\blah.log > out.log

APPLIES TO
  • Microsoft Internet Information Server 3.0
  • Microsoft Internet Information Server 4.0
  • Microsoft Internet Information Services 5.0
Keywords: 
kbfile KB296093
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support