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

Query UCMDB Data from SQL Query browser.

Highlighted
Shivshankar Yad
Senior Member

Query UCMDB Data from SQL Query browser.

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.

Regards
Shiva
*******

 

 

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

OpenVIew
1 REPLY
Alexander Arkhi
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).

Regards,
Alex
//Add this to "OnDomLoad" event