Microsoft KB Archive/839857

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

Article ID: 839857

Article Last Modified on 8/27/2004

-

APPLIES TO


 * Microsoft Office SharePoint Portal Server 2003

-





IN THIS TASK

 * SUMMARY
 * How to obtain the Ngthrlog.vbs tool
 * Overview of the Ngthrlog.vbs tool
 * How to use the Ngthrlog.vbs tool to view gatherer logs
 * Examples
 * REFERENCES



SUMMARY
This article describes how to obtain the Ngthrlog.vbs tool and how to use the tool to view information that is contained in the gatherer logs in Microsoft Office SharePoint Portal Server 2003. The Ngthrlog.vbs tool improves on and replaces the Gthrlog.vbs tool that is included in the Support\Tools folder on the SharePoint Portal Server 2003 CD-ROM.

back to the top

How to obtain the Ngthrlog.vbs tool
To obtain the Ngthrlog.vbs tool, contact Microsoft Product Support Services (PSS). For a complete list of Microsoft Product Support Services phone numbers, visit the following Microsoft Web site:

http://support.microsoft.com/default.aspx?scid=fh;[LN;CNTACTMS]

Note In special cases, charges that are ordinarily incurred for support calls may be canceled if a Microsoft Support Professional determines that a specific update will resolve your problem. The usual support costs will apply to additional support questions and to issues that do not qualify for the specific update in question.

back to the top

Overview of the Ngthrlog.vbs tool
Every time that SharePoint Portal Server 2003 creates or updates an index, SharePoint Portal Server 2003 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 not permitted by rules.

By default, SharePoint Portal Server 2003 logs index warnings and access errors. If you want to log either successful accesses or accesses that are not permitted by rules, you can 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 Ngthrlog.vbs tool to view the information that is contained in the gatherer logs. Ngthrlog.vbs is a Microsoft Visual Basic script file that connects to a database that is stored in Microsoft SQL Server, and this script file retrieves the logging information from the tables in the database.

Ngthrlog.vbs uses the following syntax:

Ngthrlog.vbs /s  /d   /c   [{/l  [ /p  ] } | /E][/u   ] [/t  ] [/q  ] [/f  ] [/r] [/n  ] [/v] [/o  ]

You can use the following command-line parameters with Ngthrlog.vbs:  /s : Use this parameter to specify the name of the database server. /d : Use this parameter to specify the name of the database that you want to query. /c : Use this parameter to specify the catalog that you want to query. For example, the name of catalog that you want to query may be Portal_Content or Non_Portal_Content. /l : Use this parameter to specify the logon ID of the user. Logon IDs are case-sensitive. /p : Use this parameter to specify the password of the LogInID parameter. /E: Use this parameter to specify a trusted connection instead of requesting a password. URL-filter: Use this parameter to specify a URL string.</li> /t : Use this parameter to specify one of the following notification (transaction) types: <ul> add</li> delete</li> modify</li></ul>

Note You can use the add transaction type or the delete transaction type only during a crawl.</li> /q : Use this parameter to specify the number of seconds before a query operation times out. The default value is 300 seconds.</li> /f : Use this parameter to specify one of the following formats for the gatherer log information: <ul> text</li> html</li> csv</li></ul>

If you do not specify an output format for the file, the default format is text.</li> /r: Use this parameter to sort the output by descending timestamp value.</li> /n : Use this parameter to specify the crawl number that you want to filter. By default, the crawl number is set to All.</li> /v: Use this parameter to specify the verbose option. When you use this option, all fields for a record are displayed.</li> /o : Use this parameter to write the results to a file in the current folder. The name of the file uses the following format:

_ _ _

You can specify one of the following output formats for the file: <ul> text</li> html</li> <li>csv</li></ul>

If you do not specify an output format for the file, the default file format is text.</li></ul>

Note To use the Ngthrlog.vbs tool to perform the procedure that this article describes, 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

How to use the Ngthrlog.vbs tool to view gatherer logs
To use the Ngthrlog.vbs tool to view gather log information: <ol> <li>Copy the Ngthrlog.vbs file to a folder on the server.</li> <li>Click Start, and then click Run.</li> <li>In the Open box, type cmd, and then click OK.</li> <li>At the command prompt, change to the directory that contains the Ngthrlog.vbs file.</li> <li>Type the following command, and then press ENTER:

cscript //h:cscript

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

back to the top

Examples
The following list contains examples of Ngthrlog.vbs command lines:
 * ngthrlog.vbs /s Server1 /d MySite_SERV /c Portal_Content /E
 * ngthrlog.vbs /s Server1 /d MySite_SERV /c Non_Portal_Content /l spsadmin /u Password1 /t add /f csv > NPC.csv
 * ngthrlog.vbs /s Server1 /d MySite_SERV /c Portal_Content /E /u &quot;test&quot; /t modify /f html > PC.html
 * ngthrlog.vbs /s Server1 /d MySite_SERV /c Portal_Content /E /u &quot;test&quot; /t modify /f html /o

<div class="references_section">