Manually running DBServerInfo stored procedures

Technote (FAQ)


Question

When the DBServerInfo script fails to run properly, how do you manually gather the DBServerInfo information?

Cause

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

Answer

  1. Log in to the server that contains your SiteProtector database.
  2. Open SQL 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.



If the above information does not resolve your issue, please contact IBM Security Systems Technical Support.

Related information

Running the SiteProtector DBServerInfo script

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

IBM Security SiteProtector System

Software version:

2.0 SP 8.0, 2.0 SP 8.1, 2.9

Operating system(s):

Windows

Reference #:

1647400

Modified date:

2013-08-26

Translate my page

Machine Translation

Content navigation