How can we integrate with HP CMDB?

HP CMDB (HP CMDB link) is HP's solution for the Configuration Management System (CMS).It's a re-brand of the Mercury uCMDB product. As with any CMDB, it has the ability to import or federate data.

Although not clearly stated, it seems that the only provider of imported data is HP Discovery and Dependency Manager (HP DDM), another Mercury product.

So the only remaining alternative is to federate data, which represents a real compelling solution, as it doesn't require to ETL (extract, transform and load) the data.

The issue arrives when multiple data sources (including HP DDM) are referring to the same resource. Although not clearly stated, HP CMDB doesn't seem to provide a way to reconcile the data, but it defers this job to HP SM7 (HP SM7), another suite of products that can consume HP CMDB data.

Bottom line: although not state clearly, there seems to be no way to load data into HP CMDB, neither there is a way to reconcile federated data.

Hard to believe? Tell me if you know anything different...

How to delete all CCMDB Authorized CI classification

Here is the script to delete all CCMDB Authorized CI classification:

delete from select classstructure where classstructureid in (select classstructureid from classusewith where objectname = 'CI')

Wills, do it at your own risk.