Unsupported content This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

DENORMALIZE_BSM_RELATIONSHIPS table

Because the BMC _CORE_BMC_BASERELATIONSHIP table used by BMC Atrium CMDB to store CI relationship data is not suitable for the reporting requirements of BMC Analytics for BSM, a new table is created during installation that prepares the operational data for use in the reports.

The installation utility populates the table using the PC_DENORMALIZE_BSM_RELATIONSHIPS procedure that retrieves BMC Business Service Class CI data from the BMC _CORE_BMC_BASERELATIONSHIP table and recursively traverses the table following the relationships that identify a service model, then stores the CI, Relationship and other denormalized data in the DENORMALIZE_BSM_RELATIONSHIPS table.

You should update the table whenever relationships are updated in BMC Atrium CMDB. See Updating the DENORMALIZE_BSM_RELATIONSHIPS table for more information.

The following table shows the detailed structure of the DENORMALIZE_BSM_RELATIONSHIPS table.

Structure of the DENORMALIZE_BSM_RELATIONSHIPS table

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*