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

  • Valuable information would be given kudos

  • 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.

  • 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

  • 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.

  • 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

  • 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.

  • 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,
  • 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

    hp_man_UCMDB10.10_DiscIntegContent_SM_Inttegration_pdf.pdf
  • any  suggestions on routine database maintenance tasks   that can be performed at sql server  level in 9.05 ?

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