Enabling Inventory assets

This topic describes how to enable assets for Inventory reporting.

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

By default, the data for the following assets is not loaded from the BMC Server Automation database to the reports data warehouse. Also, data for these assets is not migrated to BMC BladeLogic Decision Support for Server Automation version 8.2 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. These scripts are bundled in the BDSSA82-servicepackVersion-external-files.zip file.

Enabling data loading and migration of the Inventory assets for Oracle

1. Log on to SQL Plus as BSARA_DW (or the name you choose for this user).
2. If you haven't already done so, extract the scripts from the BDSSA82-servicepackVersion-external-files.zip file (see Downloading-the-BMC-BladeLogic-Decision-Support-for-Server-Automation-External-Files).
3. Run the following commands depending on your requirements:

   • For the File System asset, run the following command:

     sqlplus bsara_dw/<password>@<TNS_ENTRY>@enable_blfile_snapshot_data.sql
     

   • For the Registry asset, run the following command:

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

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

     sqlplus bsara_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. If you haven't already done so, extract the scripts from the BDSSA82-servicepackVersion-external-files.zip file (see Downloading-the-BMC-BladeLogic-Decision-Support-for-Server-Automation-External-Files).
2. Log on to the SQL Server database as BSARA_DW(or the name you choose for this user) using the sqlcmd utility for SQL Server 2005 and run the following commands depending on your requirements, as follows:

   • 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>

     where,

   • <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.