Where to get the data from CMDB Relationships at Database level
book
Article ID: 128861
calendar_today
Updated On:
Products
SUPPORT AUTOMATION- SERVERCA Service Desk Manager - Unified Self ServiceKNOWLEDGE TOOLSCA Service Management - Asset Portfolio ManagementCA 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.