Where to get the data from CMDB Relationships at Database level

book

Article ID: 128861

calendar_today

Updated On:

Products

SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service KNOWLEDGE TOOLS CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction



We need to know where to get the data showed up in under the "CMDB Relationships" tab for a Configuration Item (CI).

Environment

Service Desk Manager 14.1 and later

Resolution

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.