Select the product you need help with
FILE: PrepWebLog Utility Prepares IIS Logs for SQL Bulk InsertArticle ID: 296093 - View products that this article applies to. This article was previously published under Q296093 SUMMARY
Microsoft Knowledge Base article
296085
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.
(http://support.microsoft.com/kb/296085/EN-US/
)
HOWTO: Analyzing Web Logs with SQL
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 INFORMATIONThe following file is available for download from the Microsoft Download Center: PrepWebLog.exe
Release Date: JUN-21-2001
(http://download.microsoft.com/download/iis50/utility4/1.0/win98mexp/en-us/prepweblog.exe)
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
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:
(http://support.microsoft.com/kb/119591/EN-US/
)
How to Obtain Microsoft Support Files from Online Services
Collapse this table
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 Properties | Article Translations
 |
Back to the top
