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.