Where to get the data from CMDB Relationships at Database level
Article ID: 128861
SUPPORT AUTOMATION- SERVER
CA Service Desk Manager - Unified Self Service
CA Service Management - Asset Portfolio Management
CA Service Management - Service Desk Manager
We need to know where to get the data showed up in under the "CMDB Relationships" tab for a Configuration Item (CI).
Service Desk Manager 14.1 and later
CI's are stored in the ca_owned_resources table. The relationships are stored in the busmgt table where hier_child is the CI itself and hier_parent is/are the related CI(s).
In the ci_rel_type column is saved an ID which is the foreign key from data stored in the ci_rel_type table, which has the name of the relationship.