Enabling Inventory assets

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