Where to find in MDB the relationship between Configuration Items (CI) and Change Orders (CO)

Products

• CA Service Management - Service Desk Manager
• CA Service Desk Manager

Issue/Introduction

Where to find in MDB the relationship between Configuration Items (CI) and Change Orders (CO)

Environment

Release : 17.3

Component : SDM - Classic UI

Resolution

You can find the data stored in the usp_lrel_asset_chgnr table.

Example:

 

In the screenshot above you can see the Change Order 21 has CI named "hwast01" associated to it.

At the database level, you see in the usp_lrel_asset_chgnr table the ID's from the change order (chg table) and the ID from the CI (ca_owned_resource table)