HAM Asset CI mapping

[Vinu1]

Hi All,

My requirement is to map the fields between alm_hardware and cmbd_ci tables. I have custom choice field in alm_hardware table with choices as "A,B,C".  I need to map the custom field from alm_hardware to  " Owner Type"(OOO) field in cmdb_ci table. Please suggest me a best way to do this.

Also Please let me know whether  it  is possible to achieve  the above functionality with Asset CI mappings or should I choose BR to achieve it.

Thanks,

Vinu

[Community Alums]

Yes you can do that via Asset-CI Mapping, but you should use on both sides numeric values for the choice list you have.

For example if on asset table your choice field is having A,B,C, then the actual values should be 1,2,3 (so display value:value A:1,B:2,C:3). Same applies on the Owner Type on the CI.

This would be the best approach. Anyways, you can use as values in the asset table the values in the CI table. So if the Owner choice list value is "owner_one", just use it on the asset choice list , like A:owner_one

This would be best approach. Using business rule might bring you some issues when talking for sync between assets and CIs.

Hope this helps!

Joro

[jleach67]

But if the field is on the alm_hardware table it will not be available via Asset-CI mapping would it?  Because the Asset-CI mapping uses the alm_asset table.  I have been trying to figure out how to sync custom fields from the alm_hardware table to the cmdb_ci_radio_hardware table and have so far been unsuccessful.