This topic describes how to enable assets for Inventory reporting.

By default, the data for the following assets is not loaded from the TrueSight Server Automation database to the reports data warehouse. Therefore, you cannot see data for these assets in the built-in and ad hoc Inventory reports.

  • File System
  • Registry
  • .NET Assemblies

To enable the data loading and migration of these assets, you must run the scripts.

Enabling data loading and migration of the Inventory assets for Oracle

  1. From the command prompt, navigate to the <TSSA-DWInstallationDirectory>/bsa/dwh/sql/oracle/schema directory.
  2. Log on to SQL Plus as TSSADW_DW (or the name you choose for this user).
  3. Depending on your requirements, run one or more of the following commands:
    • For the File System asset, run the following command:

      sqlplus tssadw_dw/<password>@<TNS_ENTRY>@enable_blfile_snapshot_data.sql
    • For the Registry asset, run the following command:

      sqlplus tssadw_dw/<password>@<TNS_ENTRY>@enable_registry_snapshot_data.sql
    • For the .NET Assemblies asset, run the following command:

      sqlplus tssadw_dw/<password>@<TNS_ENTRY>@enable_dot_net_assembly_snapshot_data.sql

Enabling data loading and migration of the Inventory assets for Microsoft SQL Server

  1. From the command prompt, navigate to the <TSSA-DWInstallationDirectory>/bsa/dwh/sql/sqlserver/schema directory.
  2. Log on to the SQL Server database as TSSADW_DW (or the name you choose for this user) by using the sqlcmd utility and run the following commands depending on your requirements:
    • For the File System asset, run the following command:

      sqlcmd -d <databaseName> -U DWUser -P <TSSADWPassword> -S <serverName> -i enable_blfile_snapshot_data.sql -o <logFile>
    • For the Registry asset, run the following command:

      sqlcmd -d <databaseName> -U DWUser -P <TSSADWPassword> -S <serverName> -i enable_registry_snapshot_data.sql -o <logFile>
    • For the .NET Assemblies asset, run the following command:

      sqlcmd -d <databaseName> -U DWUser -P <TSSADWPassword> -S <serverName> -i enable_dot_net_assembly_snapshot_data.sql -o <logFile>
    • <DWUser> and <TSSADWPassword> are the database user name and password.
    • <databaseName> is the name of the database.
    • <serverName> is the server on which the database resides.
    • <logFile> is the log file to which you want to send the results of running the script.

Where to go from here

Performing the initial ETL run

Upgrade Assistance

The BMC Assisted Migration Offering (AMIGO) program is designed to assist customers with the planning of product upgrades to a newer version – “Success through proper planning”.
Explore AMIGO Program ›
Was this page helpful? Yes No Submitting... Thank you