ISA Server 2004 Tools: MSDEToText.vbs

Overview

MSDEToText.vbs converts Microsoft® Internet Security and Acceleration
(ISA) Server 2004 Standard Edition and ISA Server 2004 Enterprise
Edition Microsoft SQL Server 2000 Desktop Engine (MSDE) logs into a
text file, or displays contents of the log on the screen. You should
only run MSDEToText.vbs on the local computer on which MSDE logs are
stored.

Running MSDEToText.vbs

After downloading the tool, open a Command Prompt window. Navigate to
the folder in which you saved the script. Run the script with the
following commands:

Syntax

MSDEToText.vbs DataBase_Name {WebProxyLog|FireWallLog}
[OutputFile_Name.txt]

Parameters

DataBase_Name. The name of the MSDE database. Specify the name without
the .mdf extension.

[WebProxyLog|FireWallLog]. Specify the type of log you want to convert
to text. You must specify either WebProxyLog or FireWallLog.

OutputFile_Name.txt. Optional. If you do not specify a text file name,
the contents of the MSDE log are displayed on the screen. 

Examples

Example 1: To specify that the contents of the Web proxy log in
WebDB.mdf should be output to the screen, type the following at the
command prompt:

MSDEToText.vbs WebDB WebProxyLog

Example 2: To specify that the contents of the Firewall log in FWDB.mdf
should be output to a text file named FWLog.txt, type the following at
the command prompt:

MSDEToText.vbs FWDB FireWallLog FWLog.txt

Formatting Legend

The following table provides information about formatting.

Format	Meaning

Italic	Information that the user must supply.

Bold	Elements that the user must type exactly as shown.

Between brackets ([])	Optional items.

Between braces ({ }) or brackets ([ ]); choices separated by pipe (|).
Example: {even|odd}	Set of choices from which the user must choose only
one.



  PAGE  2      STYLEREF "Chapter Title,cht"\t  \* MERGEFORMAT  ISA
Server 2004 Tools: MSDEToText.vbs 

  STYLEREF "Heading 1,First Level Topic,h1"\t  \* MERGEFORMAT  Overview
     PAGE  3