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

Issue/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

Resolution:

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> 
</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 for more information.