Manually running DBServerInfo stored procedures

Technote (FAQ)


Question

How do you manually gather the DBServerInfo information when the DBServerInfo script fails to run properly?

Cause

In rare cases, the DBServerInfo script will fail to properly generate the DBServerInfo log file. In such a scenario, you may need to manually gather the DBServerInfo logs.

Answer

  1. Log in to the server that contains your SiteProtector Database.

  2. Open SQL Server Management Studio.

  3. Click the New Query button to open a new query window.

  4. In the menu, click Query > Results To > Results to File.

  5. Copy the following query into the query window:

    use RealSecureDB;
    execute iss_DBSI_Main
    execute iss_DBSI_Registry
    execute iss_DBSI_sensordetail
    execute iss_DBSI_desktop
    execute iss_DBSI_Licence
    execute iss_DBSI_SQLAgent
    execute iss_DBSI_LoginSPID
    execute iss_DBSI_Schedule
    execute iss_DBSI_Locks
    execute iss_DBSI_Policy
    execute iss_DBSI_EventSummary
    execute iss_DBSI_Maintanance
    execute iss_DBSI_MaintananceLog
    execute iss_DBSI_SiteFilters
    execute iss_DBSI_TSQLs
    execute iss_DBSI_Top25
    execute iss_DBSI_SensorGroup
    execute iss_DBSI_DataHistory
    execute iss_DBSI_Permissions
    execute iss_DBSI_Assets
    execute iss_DBSI_SQLDiagUtility;


  6. Press F5 to run the query.

  7. Specify the file name and location where the file should be saved.


IBM SiteProtector Documentation IBM Infrastructure Security Forums IBM Security Support Channel on YouTube IBM Fix Central Fixes and Updates IBM Security License Key and Download Center Subscribe to My Notifications for Important Product Alerts IBM Security Contact Support

Related information

Running the SiteProtector DBServerInfo script

Document information


More support for:

IBM Security SiteProtector System
Database

Software version:

3.0, 3.1, 3.1.1

Operating system(s):

Windows

Reference #:

1647400

Modified date:

2013-08-26

Translate my page

Content navigation