Cohesion - Revision history

Scoutbaker at 02:35, 15 February 2011

2011-02-15T02:35:47Z

Trzaskowski at 20:10, 27 December 2010

2010-12-27T20:10:36Z

Trzaskowski: Cohesion's integratration with CA CMDB v12 and above is supported by CA Support.

2010-12-20T16:10:14Z

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

New page

'''Cohesion Application Configuration Manager 5.0 '''

Cohesion's integratration 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.

← Older revision		Revision as of 20:10, 27 December 2010
Line 19:		Line 19:

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

@@ Line 1: / Line 1: @@
 '''Cohesion Application Configuration Manager 5.0 '''
-Cohesion's integratration with CA CMDB v12 and above is supported by CA Support.
+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.