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 BMC Server Automation database to the reports data warehouse. Additionally, data for these assets is not migrated to BMC Decision Support for Server Automation version 8.8 from earlier releases. 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 BDSSAInstallationDirectory/bsa/dwh/sql/oracle/schema directory.
2. Log on to SQL Plus as BDSSA_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 bdssa_dw/<password>@<TNS_ENTRY>@enable_blfile_snapshot_data.sql

   • For the Registry asset, run the following command:

     sqlplus bdssa_dw/<password>@<TNS_ENTRY>@enable_registry_snapshot_data.sql

   • For the .NET Assemblies asset, run the following command:

     sqlplus bdssa_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 BDSSAInstallationDirectory/bsa/dwh/sql/sqlserver/schema directory.
2. Log on to the SQL Server database as BDSSA_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 <BDSSAPassword> -S <serverName> -i enable_blfile_snapshot_data.sql -o <logFile>

   • For the Registry asset, run the following command:

     sqlcmd -d <databaseName> -U DWUser -P <BDSSAPassword> -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 <BDSSAPassword> -S <serverName> -i enable_dot_net_assembly_snapshot_data.sql -o <logFile>

   • <DWUser> and <BDSSAPassword> 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