Cohesion

Cohesion Application Configuration Manager 5.0

Cohesion's integration with CA CMDB v12 and above is supported by CA Support.

Cohesion can update the CMDB via a report given proper access to update the CMDB application. The report function creates an xml file that uploaded/inserted into the CMDB. The system checks for duplicates by looking for like: system name, host name, dns name, serial number. There is also a shared MDR number between the configuration item in CMDB and the configuration item in Cohesion. You can also export the xml file and update the CMDB manually via the command line using GRLOADER.

GRLOADER /? will give you available parameters.

typical update command is grloader -E -I -a -u username -p password -s http://host:8080 -i c:\filename.xml

to insert add the -n parameter grloader -n -E -I -a -u username -p password -s http://host:8080 -i c:\filename.xml

CA recommends no more than 500 servers per instance of Cohesion, any more then you have to add secondary servers

TroubleShooting Cohesion integration with CMDB

In running CMDB 12.1 with an externally hosted database we had many duplicate CI"s created when we tried to update the CMDB with XML from Cohesion, even though there should not have been. CA stated the MDR Registration process goes to sleep and sometimes does not reconnect properly. Killing the MDR_registration process on the server hosting the CMDB application before doing any imports seems to resolve this, as the MDR_registration process will restart automatically and make a solid connection to database to enable any imports.

SQL Tables

If you are interested in doing a query for which software is found which servers the two tables components_ui_table (software) and the cc_host table (servers)

The following query will give you results of software to server

   use cohesion
   select sw.mod_name, srv.host_name
   from components_ui_table sw
   left outer join cc_host srv
   on 
   sw.host_id = srv.host_id
   order by mod_name