Where to get the data from CMDB Relationships at Database level


Article ID: 128861


Updated On:


SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service KNOWLEDGE TOOLS 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.