Microsoft KB Archive/830330

= How to use the Gthrlog.vbs tool to view gatherer logs in SharePoint Portal Server 2003 =

PSS ID Number: 830330

Article Last Modified on 1/14/2004

-

The information in this article applies to:


 * Microsoft Office SharePoint Portal Server 2003

-





For a Microsoft SharePoint Portal Server 2001 version of this article, see 289653.



IN THIS TASK

 * SUMMARY
 * Overview
 * Use the Gthrlog.vbs tool to view gatherer logs
 * REFERENCES



SUMMARY
This article describes how to use the Gthrlog.vbs tool to view information that is contained in the gatherer logs in Microsoft Office SharePoint Portal Server 2003.

Note To use the Gthrlog.vbs tool to perform the procedure that is described in this article, you must be logged on to SharePoint Portal Server 2003 by using an account that has appropriate permissions to access the SQL Server databases. For example, you must be logged on to SharePoint Portal Server 2003 by using the same account that the CentralAdminAppPool application pool in Microsoft Internet Information Services (IIS) is configured to use.

back to the top

Overview
Every time that SharePoint Portal Server creates an index or updates an index, SharePoint Portal Server creates a gatherer log entry in a table in the component settings database for the portal site. Log entries contain data about URLs that are accessed while the index is being created. The log can record successful accesses, indexing warnings, access errors, and accesses that are disallowed by rules.

By default, SharePoint Portal Server 2003 logs index warnings and access errors. If you want to log successful accesses or accesses that are disallowed by rules, you must configure these options.

You can view the content of gatherer logs on the Gatherer Log Details page of the portal site. You can also use the Gthrlog.vbs tool to view the information that is contained in the gatherer logs. Gthrlog.vbs is an unsupported tool that is located in the Support\Tools folder of the SharePoint Portal Server 2003 CD-ROM. Gthrlog.vbs is a Microsoft Visual Basic script file that connects to a database that is stored in Microsoft SQL Server and retrieves the logging information from the tables in the database.

Gthrlog.vbs uses the following syntax:

gthrlog.vbs  [/u  -filter] [/b] [/n] [/t  ] [/e  ] [/s  ]

The following list shows the command-line parameters that you can use with Gthrlog.vbs:  URL-filter: Use this parameter to specify a URL. You can use wild characters, including the asterisk and the question mark. /b: Use this parameter to order the output by descending timestamp. /n : Use this parameter to display any messages that do not match the filter. /t: Use this parameter to specify the notification (transaction) type. The following list shows the transaction types that that you can use:  a: add d: delete</li> m: modify</li></ul>

Note You can use the add transaction type or the delete transaction type only during crawls.</li> /e: Use this parameter to specify the error mask, such as HRESULT.</li> /s: Use this parameter to specify the transaction status, such as HRESULT.</li></ul>

back to the top

Use the Gthrlog.vbs tool to view gatherer logs
To use the Gthrlog.vbs tool to view gather log information: <ol> Copy the Gthrlog.vbs file that is located in the Support\Tools folder of the SharePoint Portal Server 2003 CD-ROM to a folder on your server.

Note You may have to edit the Connection.Open &quot;Database=&quot; & wscript.Arguments(0) line of the Gthrlog.vbs file to include an entry for the server. For example, if you installed SharePoint Portal Server 2003 with Microsoft SQL Server Desktop Engine (MSDE), modify the line as follows:

Connection.Open &quot;Server=.\Sharepoint; Database=&quot; & wscript.Arguments(0)

If you installed SharePoint Portal Server with Microsoft SQL Server 2000, modify the line as follows, where  is the name of your server:

Connection.Open &quot;Server= ; Database=&quot; & wscript.Arguments(0)

</li> Click Start, and then click Run.</li> In the Open box, type cmd, and then click OK.</li> At the command prompt, change to the folder that contains the Gthrlog.vbs file.</li> Type the following command, and then press ENTER:

cscript //h:cscript

</li> Type the gthrlog.vbs command line that you want to run, and then press ENTER.

For example, if you want to view the gatherer log of non-portal content in the component settings database of a portal site named MyPortal, type the following line, and then press ENTER:

gthrlog.vbs myportal_SERV non_portal_content

</li></ol>

back to the top

<div class="references_section">