Highlighted
Honored Contributor.
Honored Contributor.
163 views

What is the table that save relationship between cis (example: node and ip) in ucmdb

Jump to solution

Hi Good day,

I Need identify What is the table that save relationship between cis (example: node and ip) in the BD ucmdb.

Thanks,

0 Likes
1 Solution

Accepted Solutions
Highlighted
Micro Focus Expert
Micro Focus Expert

Re: What is the table that save relationship between cis (example: node and ip) in ucmdb

Jump to solution

It  is worth noting that the UCMDB schema is not documented and can change with any given release / CUP / content pack.  If this table is renamed for any reason, then your queries may not work.  It is best to always use the UCMDB UI to generate reports or such things as you need rather than the database itself.

Hope this helps,
Keith Paschal
UCMDB Worldwide Support Lead
Micro Focus Support
If you find this or any post resolves your issue, please be sure to mark it as an accepted solution."

Click the KUDOS star on the left to say 'Thanks'

View solution in original post

0 Likes
3 Replies
Highlighted
Outstanding Contributor.. Outstanding Contributor..
Outstanding Contributor..

Re: What is the table that save relationship between cis (example: node and ip) in ucmdb

Jump to solution

Hello Marsella ,

You may create a TQL and after calculation you can review the DB logs to see the table that are been modified.

Best Regards,

Melissa Carranza Mejias
Customer Support Engineer

If you find that this or any other post resolves your issue, please be sure to mark it as an accepted solution.
If you are satisfied with anyone’s response please remember to give them a KUDOS by clicking on the STAR at the bottom left of the post and show your appreciation. “
0 Likes
Highlighted
Regular Contributor.. Regular Contributor..
Regular Contributor..

Re: What is the table that save relationship between cis (example: node and ip) in ucmdb

Jump to solution

Hi Marsella,

In version 10.30 of UCMDB, the names of the tables that have the information of the relations between CIs depends on the type of relation, for example the relations of type "containment" are in the table "cdm_containment_1".

 

 

0 Likes
Highlighted
Micro Focus Expert
Micro Focus Expert

Re: What is the table that save relationship between cis (example: node and ip) in ucmdb

Jump to solution

It  is worth noting that the UCMDB schema is not documented and can change with any given release / CUP / content pack.  If this table is renamed for any reason, then your queries may not work.  It is best to always use the UCMDB UI to generate reports or such things as you need rather than the database itself.

Hope this helps,
Keith Paschal
UCMDB Worldwide Support Lead
Micro Focus Support
If you find this or any post resolves your issue, please be sure to mark it as an accepted solution."

Click the KUDOS star on the left to say 'Thanks'

View solution in original post

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.