Highlighted
Trusted Contributor.
Trusted Contributor.
5409 views

HP uCMDB Database Schema

Hi Team,

 

Would like to know if we can get HP uCMDB database Schema. This is required in the process of understanding few fields like "Define impacted" equavalent value in DB. Likewise, we have uncertainity to understand with regards fields. Please help us to provide DB Schema or way to get information.

 

 

P.S. This thread has been moved from HP Service Manager / Service Center Support and News Forum to CMS and Discovery Support and News Forum. - Hp Forum Moderator

0 Likes
10 Replies
Highlighted
Trusted Contributor.
Trusted Contributor.

Re: HP uCMDB Database Schema

Valuable information would be given kudos

0 Likes
Highlighted
Absent Member.
Absent Member.

Re: HP uCMDB Database Schema

Hello iconicstar, 🙂

 

    Not much information is available for the UCMDB schema however I will try to help you. I think i found information which may be helpful for you:

 

uCMDB creates a lot of database objects like tables,stored procedure , views, user defined data types. We can list all those objects and see the status of all the objects.  - which represents actually the schema UCMDB uses.  🙂
 
To list the various dataobjects created by the uCMDB 9.05(for example ) we can run the below query.

Owner = name of the ucmdb schema. It can be either hisotry schema or the main schema.

SELECT owner,
object_type,
object_name,
status
FROM dba_objects
WHERE OWNER = 'UCMDB_1' ORDER BY owner, object_type, object_name;

 

For example if we run  against the history schema we can see the below list.


OWNER OBJECT_TYPE OBJECT_NAME STATUS
UCMDBHIS FUNCTION TRUNCATETABLEINAUTONOMOUSTRX VALID
UCMDBHIS INDEX IX1_ARCHIVE_CHUNK_ARCHIVE_ID VALID
UCMDBHIS INDEX IX1_CDM_TMP_OBJID_CMDB_ID VALID
UCMDBHIS INDEX IX1_CHANGE_ID_TMP_ID VALID
UCMDBHIS INDEX IX1_HIST_EVENTS_E_144855667 VALID
UCMDBHIS INDEX IX1_HIST_EVENTS_EVENT_TIME VALID
UCMDBHIS INDEX IX1_HIST_EVENTS_O_356112647 VALID
UCMDBHIS INDEX IX1_HIST_INF_BOOL_387469050 VALID
UCMDBHIS INDEX IX1_HIST_INF_BOOL_END_TIME VALID
UCMDBHIS INDEX IX1_HIST_INF_BOOL_OBJECT_ID VALID
UCMDBHIS INDEX IX1_HIST_INF_BYTE_END_TIME VALID
UCMDBHIS INDEX IX1_HIST_INF_BYTE_OBJECT_ID VALID
UCMDBHIS INDEX IX1_HIST_INF_DATE_1223819702 VALID
UCMDBHIS INDEX IX1_HIST_INF_DATE_END_TIME VALID
UCMDBHIS INDEX IX1_HIST_INF_DATE_OBJECT_ID VALID
UCMDBHIS INDEX IX1_HIST_INF_DBL__2141191086 VALID
UCMDBHIS INDEX IX1_HIST_INF_DBL_END_TIME VALID
UCMDBHIS INDEX IX1_HIST_INF_DBL_OBJECT_ID VALID
UCMDBHIS INDEX IX1_HIST_INF_FLT__646898578 VALID
UCMDBHIS INDEX IX1_HIST_INF_FLT_END_TIME VALID
UCMDBHIS INDEX IX1_HIST_INF_FLT_OBJECT_ID VALID
UCMDBHIS INDEX IX1_HIST_INF_INT__1583541508 VALID
UCMDBHIS INDEX IX1_HIST_INF_INT__1781925704 VALID
UCMDBHIS INDEX IX1_HIST_INF_INT__643979279 VALID
UCMDBHIS INDEX IX1_HIST_INF_INT_END_TIME VALID
UCMDBHIS INDEX IX1_HIST_INF_INT_OBJECT_ID VALID
UCMDBHIS INDEX IX1_HIST_INF_LONG_188296920 VALID
UCMDBHIS INDEX IX1_HIST_INF_LONG_END_TIME VALID
UCMDBHIS INDEX IX1_HIST_INF_LONG_OBJECT_ID VALID
UCMDBHIS INDEX IX1_HIST_INF_STR__448395206 VALID
UCMDBHIS INDEX IX1_HIST_INF_STR__952128710 VALID
UCMDBHIS INDEX IX1_HIST_INF_STR_END_TIME VALID
UCMDBHIS INDEX IX1_HIST_INF_STR_OBJECT_ID VALID
UCMDBHIS INDEX IX1_HIST_INF_XML_END_TIME VALID
UCMDBHIS INDEX IX1_HIST_INF_XML_OBJECT_ID VALID
UCMDBHIS INDEX IX1_HIST_MULTI_IN_1229732656 VALID
UCMDBHIS INDEX IX1_HIST_MULTI_ST_1183635694 VALID
UCMDBHIS INDEX IX1_IDS_TO_DATES_TMP_CMDB_ID VALID
UCMDBHIS INDEX IX1_VIEW_ARCHIVE_TIMESTAMP VALID
UCMDBHIS INDEX IX1_VIEW_ARCHIVE_VIEW_NAME VALID
UCMDBHIS INDEX PK_ARCHIVE_CHUNK VALID
UCMDBHIS INDEX PK_HIST_EVENTS VALID
UCMDBHIS INDEX PK_HIST_INF_BOOL VALID
UCMDBHIS INDEX PK_HIST_INF_BYTE VALID
UCMDBHIS INDEX PK_HIST_INF_DATE VALID
UCMDBHIS INDEX PK_HIST_INF_DBL VALID
UCMDBHIS INDEX PK_HIST_INF_FLT VALID
UCMDBHIS INDEX PK_HIST_INF_INT VALID
UCMDBHIS INDEX PK_HIST_INF_INT_LIST VALID
UCMDBHIS INDEX PK_HIST_INF_LONG VALID
UCMDBHIS INDEX PK_HIST_INF_STR VALID
UCMDBHIS INDEX PK_HIST_INF_STR_LIST VALID
UCMDBHIS INDEX PK_HIST_INF_XML VALID
UCMDBHIS INDEX PK_VIEW_ARCHIVE VALID
UCMDBHIS INDEX SYS_IL0000121340C00005$$ VALID
UCMDBHIS INDEX SYS_IL0000121343C00005$$ VALID
UCMDBHIS INDEX SYS_IL0000121349C00006$$ VALID
UCMDBHIS INDEX SYS_IL0000121349C00007$$ VALID
UCMDBHIS INDEX SYS_IL0000121349C00008$$ VALID
UCMDBHIS INDEX SYS_IL0000121356C00003$$ VALID
UCMDBHIS INDEX UIX1_VIEW_ARCHIVE_319439095 VALID
UCMDBHIS LOB SYS_LOB0000121340C00005$$ VALID
UCMDBHIS LOB SYS_LOB0000121343C00005$$ VALID
UCMDBHIS LOB SYS_LOB0000121349C00006$$ VALID
UCMDBHIS LOB SYS_LOB0000121349C00007$$ VALID
UCMDBHIS LOB SYS_LOB0000121349C00008$$ VALID
UCMDBHIS LOB SYS_LOB0000121356C00003$$ VALID
UCMDBHIS PROCEDURE INSERTINAUTOTRX_INT INVALID
UCMDBHIS PROCEDURE INSERTINAUTOTRX_OBJID VALID
UCMDBHIS PROCEDURE INSERTINAUTOTRX_STR INVALID
UCMDBHIS TABLE ARCHIVE_CHUNK VALID
UCMDBHIS TABLE CDM_TMP_OBJID VALID
UCMDBHIS TABLE CHANGE_ID_TMP VALID
UCMDBHIS TABLE HIST_EVENTS VALID
UCMDBHIS TABLE HIST_INF_BOOL VALID
UCMDBHIS TABLE HIST_INF_BYTE VALID
UCMDBHIS TABLE HIST_INF_DATE VALID
UCMDBHIS TABLE HIST_INF_DBL VALID
UCMDBHIS TABLE HIST_INF_FLT VALID
UCMDBHIS TABLE HIST_INF_INT VALID
UCMDBHIS TABLE HIST_INF_INT_LIST VALID
UCMDBHIS TABLE HIST_INF_LONG VALID
UCMDBHIS TABLE HIST_INF_STR VALID
UCMDBHIS TABLE HIST_INF_STR_LIST VALID
UCMDBHIS TABLE HIST_INF_XML VALID
UCMDBHIS TABLE HIST_MULTI_INT_LIST VALID
UCMDBHIS TABLE HIST_MULTI_STR_LIST VALID
UCMDBHIS TABLE IDS_TO_DATES_TMP VALID
UCMDBHIS TABLE VIEW_ARCHIVE VALID
UCMDBHIS TYPE NUMBER22_TABLE VALID
UCMDBHIS TYPE NUMBER_TABLE VALID
UCMDBHIS TYPE RAW_TABLE VALID
UCMDBHIS TYPE VARCHAR2_TABLE VALID


Many times we can see in the logs, specific object is missing. If status is invalid query might get the result as object doesnt exists.

Please note that this query is tested for oracle DB. It might be different for the MSSQL as system database might be different with MSSQL. The above output is taken from a 9.05 server.

HP Support
If you find that this or any post resolved your issue, please be sure
to mark it as an accepted solution.
Please also give kudo if you find it interesting 🙂
Highlighted
Absent Member.
Absent Member.

Re: HP uCMDB Database Schema

Hi again,

 

 Other helpful information you may find in the modeling guide here:
http://support.openview.hp.com/selfsolve/document/KM1347855

 

For example on page 85 - starting.

Sending the guide attached too

HP Support
If you find that this or any post resolved your issue, please be sure
to mark it as an accepted solution.
Please also give kudo if you find it interesting 🙂
Highlighted
Trusted Contributor.
Trusted Contributor.

Re: HP uCMDB Database Schema

Thanks for the valuable response. I have just started the tool to explore.

Need few clarifications on below query.

 

If there is a impact is defined in between CIs, which field can be referred from DB.

Like wise need to get information for redundency, various status of CI.

0 Likes
Highlighted
Micro Focus Expert
Micro Focus Expert

Re: HP uCMDB Database Schema

Hello iconicstar,
Thank you for opening this topic.

 

You can easily explore the DB Schema by using 'SQL Server Management Studio' for MSSQL or 'Oracle SQL Developer' for Oracle.

 

In case you want not to store any CIs into uCMDB you can use a Federation integration, so the federated data will not be physically present in UCMDB.

Best Regards,
Nikola

------------------------
Nikola Todorov
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
Highlighted
Trusted Contributor.
Trusted Contributor.

Re: HP uCMDB Database Schema

Thank you for the response. By looking at SQL studio, cant able to understand how the tables are interconnected with fields.

I am putting this question to check following feasabilities.

hasimpact has field in DB where we can pick it for web services integration.

Likewise need to tweek for other fields too.

 

Need example for Federation how it can be proceed with uCMDB.

0 Likes
Highlighted
Absent Member.
Absent Member.

Re: HP uCMDB Database Schema

Hi,

Just want to add above posts, that looking at DB you can see the interconnection at DB level but there will surely be business logics by which data will be processed at application level.

It is just like SM where data go to different table by SM expression/syntax and scripts. These do not exists at DB and you will any related objects in DB schema.

So you better should know the app level interface and expressions configured.

Hth,
____________________________________
Assign Kudo, if found post useful and mark it accepted if solves the issue.
0 Likes
Highlighted
Micro Focus Expert
Micro Focus Expert

Re: HP uCMDB Database Schema

Hello iconicstar,
Thank you for asking.

 

Please take a look at the attached guide. Please scroll to page 44 and check the information below the title 'Examples of Using Federation'

 

Best Regards,
Nikola

------------------------
Nikola Todorov
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
Highlighted
Absent Member.
Absent Member.

Re: HP uCMDB Database Schema

any  suggestions on routine database maintenance tasks   that can be performed at sql server  level in 9.05 ?

0 Likes
Highlighted
Honored Contributor.. Honored Contributor..
Honored Contributor..

Re: HP uCMDB Database Schema

There is a UCMDB 9.05 Database Guide PDF available which is attached to this post.

Chapter 6 starting on page 57 is titled Maintaing Microsoft SQL Server Databases

Rey Lejano

effectualsystems.com
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.