How to add additional attributes to the Spectrum Modeling Gateway cmdb export

Document ID : KB000107593
Last Modified Date : 23/07/2018
Show Technical Document Details
Introduction:
This knowledge document discusses how to add additional attributes to the Spectrum Modeling Gateway cmdb export
Environment:
CA Spectrum all versions on all operating systems
Instructions:
The following are the instructions to add the Location attribute id 0x23000d and ContactPerson attribute id 0x23000c to the Spectrum Modeling Gateway cmdb export output:

1. Log into the SpectroSERVER system as the user that owns the Spectrum installaiton

2. Make a backup of the $SPECROOT/SS-Tools/.cmdbresource.xml file

3. Edit the .cmdbresource.xml file and add the following tags highlighted below:

<CMDBAttributeMapping> 
<CMDBAttribute>description</CMDBAttribute> 
<SPECTRUMAttribute>0x12c03</SPECTRUMAttribute> <!-- USER_AssetDescription --> 
</CMDBAttributeMapping> 

<CMDBAttributeMapping> 
<CMDBAttribute>location</CMDBAttribute> 
<SPECTRUMAttribute>0x23000d</SPECTRUMAttribute> 
</CMDBAttributeMapping> 

<CMDBAttributeMapping> 
<CMDBAttribute>contact</CMDBAttribute> 
<SPECTRUMAttribute>0x23000c</SPECTRUMAttribute> 
</CMDBAttributeMapping> ​


When the Modeling Gateway cmdb export is run, you should now see "location" and "contact" in the output IF the model has these attributes populated:

<GRLoader> 
<ci> 
<class>Network Switch</class> 
<mac_address>00:10:7b:36:89:99</mac_address> 
<system_name>Sim15090:Lab-A1</system_name> 
<contact>CA Technologies</contact> 
<name>Sim15090:Lab-A1</name> 
<description>Lab sim 15090</description> 
<network_address>10.241.248.19</network_address> 
<serial_number>08859477</serial_number> 
<location>273 Corporate Drive Portsmouth, NH 03391</location> 
<alarm_id>1.2.3.4</alarm_id> 
<federated_asset_id>0x4000092</federated_asset_id> 
<ip_mgmt_addr>1.2.3.4</ip_mgmt_addr> 
<mdr_class>SPECTRUM</mdr_class> 
<mdr_name>OneClick</mdr_name> 
</ci> 
</GRLoader> 
 
Additional Information:
Please refer to the "Modeling Gateway Toolkit" section of the documentation located at  https://docops.ca.com/ca-spectrum/10-2-3/en/customizing/modeling-gateway-toolkit for more information.