Mapping of field in Asset & CI

[_bhishek]

Hi All,

I want to map one field named as 'end of life'.How can i map this field in Asset & CI .This field is available in alm_hardware table and cmdb_ci_hardware table.

Please suggest.

Thanks .

[Gundeep Singh]

Hi Abhishek,

You can try one thing go to the dictionary of Asset field and click on Advanced View after that in Attributes section remove the data from there please find screenshot below.

Now create one field with type as table name and make the Asset Field  dependent on this table field now select the table alm_hardware from it you will be able to see the hardware field too do the similar things for Ci Field too .Please find screenshot below for sample, Region field i have created on alm_hardware table ,i have tried it and it worked correctly for me.

Mark it Helpful or correct if it works for you.

Regards,

Gundeep Singh

[_bhishek]

Hi Gundeep,

Thanks for your response .

I have checked this .If we will give alm_hardware table in attribute.Then we will get alm_hardware table fields.

What would be impact if we will change this as we are getting alm_asset table OOB.

Is there any other way ,if we can achieve with out changing existing functionality .if we can sync cmdb_ci_ hardware and alm_hardware table field.

Thanks.

[Gundeep Singh]

Hi Abhishek,

Dont change the attribute just remove the whole attribute field and make it table dependent this wasy it becomes more flexible as you can select any asset child table or any CI child table.

I dont think this will impact anything as in the script includes where it is setting the CI fields from asset it will get set perfectly there.

Regards,

Gundeep Singh

[_bhishek]

Hi Gundeep,

I have removed attribute of asset field  in Asset-CI field mapping table .

I tried to add dependent table for field in alm_hardware table .But I am not getting Asset-Ci mapping table there .

Also i have a query ,If we will remove attribute,then how it will take all field from asset table.

Please suggest.

[Gundeep Singh]

Hi Abhishek,

You can define the table for every record where in one you can select alm_hardware and in another mapping you can use asset table .

Regards,

Gundeep Singh