OpenText product name changes coming to the community soon! Learn more.

Wikis - Page

(UCMDB)Support Tip: Which table are the relationships (such as composition, usage, containment) stored?

0 Likes

Issue
HyperV host is connected to Virtual Layer Software and Virtual Layer Software is connected to Guest OS.
The Guest OS is then connected to the interface. In which table are the above relationships (such as composition, usage,containment) stored?


Solution
Get A_ROOT_CONTAINER
Select * from dbo.CDM_INTERFACE_1

The A_ROOT_CONTAINER obtained above is used as a query condition, which is consistent with the CMD_ID in dbo.CDM_NT_1,and the relevant information of Windows CI can be obtained.
Select * from dbo.CDM_NT_1
where CMD_ID=

For the other relationships,it can be queried by the table: dbo.CDM_USAGE_1 ,dbo.CDM_CONTAINMENT_1

Note
Database tables are sensitive information and are not within the scope of support.
Therefore, if business problems arise due to frequent database access in the future, support will not support it, so please use it with caution.

Labels:

Support Tips/Knowledge Docs
Comment List
Related
Recommended