Cohesion

2011-02-15T02:35:47Z

Scoutbaker:

'''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

SDU - User contributions [en]

Cohesion