Relation between Configuration Item and Service offering fields

[bondita1]

Hello Team,

I want to export data from the table: alm_hardware.list and need to save the corresponding values of Configuration Item, Service, and Service Offering in the Incident table.
While I'm able to retrieve the Configuration Item value successfully,
I'm facing difficulty in obtaining the values for the remaining two fields (Service and Service Offering).
How the mapping works and from where can I get the exact value, any insights or assistance on this matter would be greatly appreciated.
Thank you in advance!

[bondita1]

Hi @Ram S , Could you please provide a detailed explanation on how to create a reference table and how to map the fields accordingly?

Thanks

[Ram S]

That field needs to be there or should be available on the target table(in your example alm_harware) or at least on any reference field table(suppose cmdb_ci but could be any field on the alm_harware table).

In the 1st scenario, you are able to map the 'configuration item' field because it is directly available on the 'alm_harware' table but "Service and Service Offering" is not(as you can see in my previous screenshot). So if there is a business requirement then you can create a custom reference type field on the alm_hardware table with names 'service' and 'service offering' and auto-populate values of those fields as you have done for the 'configuration item'. (Note: new custom field creation must be confirmed with the business)

Also as I can see Model and Model ID are common fields you can try using some logic on that.