Asset to CI mapping for extended CI fields

VernYerem
Tera Expert

The field IMEI exists in alm_hardware and in cmdb_ci_handheld_computing.

In Asset-CI mapping, it looks like can only map fields from the base CI Table (cmdb_ci).

In the advance view where you can add conditions, you can expand Handheld Computing devices to see it's IMEI field.

 

VernYerem_0-1725983267072.png

 

Any idea how I can map the alm_asset.IMEI to cmdb_ci_handheld_computing.IMEI?

2 REPLIES 2

stevevandermeer
ServiceNow Employee
ServiceNow Employee

Hi, Did you get anywhere with this ? I've got the same issue.

I ended up using business rules. One for each table to catch if the IMEI changes, and if update the related record's field. For example, here is a rule on our cmdb_ci_handheld_computing table:

VernYerem_0-1756127422551.png

Then in the advanced tab, a small script to update the related record:

VernYerem_1-1756127456106.png

 

Script:

(function executeRule(current, previous /*null when async*/) {

var asset = new GlideRecord('alm_hardware');
asset.get(current.asset);
asset.imei=current.imei;
asset.update();

})(current, previous);