Universal Discovery & CMDB User Discussions

This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Table in ucmdb database

Aleksandr Gorbunov over 4 years ago

Hello,

tell me how to look at what type of CI tables in the database belong? I need to find out which table belongs to the type of CI: databace schema.

Thank you in advance for your help.

Top Replies

popadiyski over 4 years ago in reply to Aleksandr Gorbunov +1

CDM_ tables are for the CIs. HDM_ ones are for the history - change of attributes, etc. (they are used when you select CI History) Cheers, Petko Popadiyski Freelance Microfocus CMS UCMDB Consulting
popadiyski over 4 years ago in reply to Aleksandr Gorbunov +1

Hi, CDM_HOST_NODE_1 has the Computer CIs. Most probably you have 0 Computer CIs, but you have CIs in the subclasses - Windows, Unix, etc. You have to check each table individually (CDM_NT_1, CDM_UNIT_1…
Taylan over 1 year ago in reply to PraveenShan +1 suggested

Hello, I think the URM_RESOURCES table stored the queries and the views. Regars Taylan

0 popadiyski over 4 years ago

Database Schema is probably a parent class for your CI model and you don't have any CIs in it. However in all the cases the method is the same. You have to go to CI Type manager and see what is the Name of the class. For Databashe Schema it is "database_instance". Then you add to that CDM_ prefix and _1 suffix. You end up with CDM_DATABASE_INSTANCE_1, where you can find the instances of this class. In case that the class is empty, you better search the subtypes.

Regards,
Petko
Cancel
Vote Up 0 Vote Down

Cancel
0 Aleksandr Gorbunov over 4 years ago in reply to popadiyski

Hello,
Thank you for information. I understood everything and found it in the database.
Cancel
Vote Up 0 Vote Down

Cancel
0 Aleksandr Gorbunov over 4 years ago in reply to popadiyski

And please tell me more if the tables are designated as : CDM_prefix and_1 suffix, which is then indicated as: CDM_prefix and_1 suffix, which is then indicated as: HDM_prefix and_1 ? Interested in what kind of tables HDM ?
Cancel
Vote Up 0 Vote Down

Cancel
0 popadiyski over 4 years ago in reply to Aleksandr Gorbunov

CDM_ tables are for the CIs. HDM_ ones are for the history - change of attributes, etc. (they are used when you select CI History)
Cheers,
Petko Popadiyski
Freelance Microfocus CMS UCMDB Consulting
Cancel
Vote Up +1 Vote Down

Cancel
0 Aleksandr Gorbunov over 4 years ago in reply to popadiyski

Well. thanks for the information
Cancel
Vote Up 0 Vote Down

Cancel
0 Aleksandr Gorbunov over 4 years ago in reply to popadiyski

Hello, I would like to ask you one more question. In the database I wanted to find the field " Is Candidate For Deletion" in the type CI node. I opened the table "CDM_HOST_NODE_1" but there is no this parameter and there are not many of which. Tell me how to look for necessary attributes in the database, there are just a lot of tables and it is not clear which one to look for.
Cancel
Vote Up 0 Vote Down

Cancel
0 popadiyski over 4 years ago in reply to Aleksandr Gorbunov

Hi,
CDM_HOST_NODE_1 has the Computer CIs. Most probably you have 0 Computer CIs, but you have CIs in the subclasses - Windows, Unix, etc. You have to check each table individually (CDM_NT_1, CDM_UNIT_1).
Petko
Cancel
Vote Up +1 Vote Down

Cancel
0 PraveenShan over 1 year ago

Hi Gorbunov,

I was looking for the table name where UCMDB queries and views are stored.

Any help will be much appreciated.

Thanks,

Praveen
Cancel
Vote Up 0 Vote Down

Cancel
Suggested Answer

0 Taylan over 1 year ago in reply to PraveenShan

Hello,

I think the URM_RESOURCES table stored the queries and the views.

Regars

Taylan
Cancel
Vote Up +1 Vote Down

Cancel

Menu

Universal Discovery & CMDB User Discussions

Verified Answers

Table in ucmdb database

Top Replies

Suggested Answer

Resources