Customization of Attribute Mappings and Relationships

Customization › Customization of Attribute Mappings and Relationships

Customization of Attribute Mappings and Relationships

Using the CA CMDB Export Report to integrate CA Configuration Automation and CA CMDB maps CI data between the products.

Important! Back up your tables before you update them with the report scripts. To back up your tables, drop the tables that you must restore back to their original form and execute the SQL script that corresponds to the required table from the given patch. This action populates the table again. To execute the scripts, the CA Configuration Automation r12.8 database user must have access to add and update database objects to SQL Server or Oracle.

The following tables correspond to how CIs map in this integration:

Use the sqlcmd command to back up a table, such as the following examples:

sqlcmd -s servername -d mdb -q "SELECT * INTO acmbo_attrmappingorig FROM acmbo_attrmapping
sqlcmd -s servername -d mdb -q "SELECT * INTO acmbo_classmappingorig FROM acmbo_classmapping 
sqlcmd -s servername -d mdb -q "SELECT * INTO acmbo_relshmappingorig FROM acmbo_relshmapping

You restore the original backups by running the following commands:

sqlcmd -s servername -d mdb -q "SELECT * INTO acmbo_attrmapping FROM acmbo_attrmappingorig
sqlcmd -s servername -d mdb -q "SELECT * INTO acmbo_classmapping FROM acmbo_classmappinggorig
sqlcmd -s servername -d mdb -q "SELECT * INTO acmbo_relshmapping FROM acmbo_relshmappingorig

acmbo_attrmapping Table

The acmbo_attrmapping table specifies the different CIs and the corresponding mapping information of attributes in CA Configuration Automation and CA CMDB with the following example query results:

select * from acmbo_attrmapping;

CI	CA Configuration Automation Attribute	CA CMDB Attribute
server	ip_address	alarm_id
server	domainname	dns_name
server	host_id	federated_asset_id
server	mac_address	mac_address
server	make	manufacturer
server	model	model
server	serialno	serial_number
server	system_name	system_name

For example, the ip_address attribute of a Server CI in CA Configuration Automation refers to the alarm_id attribute in CA CMDB.

If you want to customize the ip_address attribute in CA Configuration Automation to IPAddress in CA CMDB, you update the acmbo_attrmapping table, such as in the following example:

update acmbo_attrmapping set cmdbattribute='IPAddress' where ci='server' and acmattribute='ip_address'

acmbo_classmapping Table

The acmbo_classmapping table specifies the different CIs and the corresponding class, family information of different CIs in CA Configuration Automation and CA CMDB with the following example query results:

select * from acmbo_classmapping;

CI	Component Name	CA CMDB Family	CA CMDB Class
component	AIX	Software.Operating System	AIX OS
component	BSD Unix	Software.Operating System	Unix OS
component	HP-UX	Software.Operating System	HP UX OS
component	Red Hat Linux	Software.Operating System	Linux OS
component	Solaris	Software.Operating System	Sun OS

For example, if you want to customize the class or family attribute in CA CMDB, then you update the acmbo_classmapping table, such as in the following example:

update acmbo_classmapping set cmdbclass='AIX' where ci='component' and cmdbclass='AIX OS' and componentname='AIX' and cmdbfamily='Software.Operating System'

acmbo_relshpmapping Table

The acmbo_relshpmapping table specifies the different CIs and the corresponding relationship information CA Configuration Automation and CA CMDB with the following example query results:

select * from acmbo_relshpmapping;

Source CI	Target CI	Relationship
server	server	communicates with
server	Hard Drive	contains
server	virtual	is the parent of
server	component	hosts
server	service	runs
server	lpar	is the parent of
server	nic	contains
server	File System	contains

For example, if you want to customize the relationship attribute in CA CMDB, then you update the acmbo_relshpmapping table, such as in the following example:

update acmbo_relshpmapping set relationship='hosts' where ci='server' and targetci='component' and relationship='communicates with'

Customize the Report XML to Include or Exclude delete_flag

If you do not want to update superseded CIs with data every time an update runs from CA Configuration Automation, avoid populating the <delete_flag> in the input XML.

To exclude or include <delete_flag>, execute the appropriate script in the CA Configuration Automation database:

To exclude delete_flag from the report XML:

update acmbo_attrmapping set ci = 'component_inactivate' where acmattribute = 'delete_flag'

To include delete_flag from the report XML:

update acmbo_attrmapping set ci = 'component' where acmattribute = 'delete_flag'