UCMDB and UD Practitioners Forum (Previously CMS)
Showing results for 
Search instead for 
Do you mean 

Query UCMDB Data from SQL Query browser.

Super Advisor

Query UCMDB Data from SQL Query browser.

[ Edited ]

We would need to query UCMDB data through SQL Query browser for integration UCMDB with our internal charge back system.

When check the data in the table the CMDB_ID is in binary format so cannot relate to another table.

Appreciate if you can let us know how can i read the CMDB_ID also provide us the database model diagram or is there any other method for quering SQL table.




P.S. This thread has been moved from Application Perf Mgmt (BAC / BSM) Support and News Forum to CMS and Discovery Support and News Forum. - Hp Forum Moderator

Honored Contributor

Re: Query UCMDB Data from SQL Query browser.

Hello Shiva,

Querying UCMDB DB is highly non-recommended approach, as there's no guarantee that HP will maintain the existing DB schema and not upgrade it between service packs/versions.

The best way to query UCMDB from external tool is to use Java/WebServices API (you can find examples in development reference).

//Add this to "OnDomLoad" event