How update computer (cmdb_ci_computer) tabel data using transform map as target table is cmdb_ci ?

kumar22
Tera Contributor

‎03-15-2022 05:29 AM

Hi Team,

We have an existing transform map to update the data using the excel type Data source. Here we're trying map CPU Name and CPU type with excel data. But there field's are in computer table hence couldn't get in field mapping.

Target table - cmdb_ci

Fields to me map - CPU Name & CPU type

Source fields - CPUName & CPYType

Please sugget me how can i get these fields in existing transform map? 

Thanks in advance..

 

Labels:
0 Helpfuls
  • 600 Views
2 REPLIES 2

Saiganeshraja
Kilo Sage
Kilo Sage

‎03-15-2022 06:44 AM

Can you share the transform map script.

0 Helpfuls

Subrahmanyam2
Giga Guru

‎03-15-2022 07:28 AM

Hi Kumar,

ServiceNow uses the concept of inheritance, to display the fields based on the hierarchy level you are in.
It is suggestable to use target table as "cmdb_ci_computer" if you want to see the fields from "cmdb_ci_computer" and its parent level table.

There should be different imports and transform maps for different targets. One map does not fit all.
Although you may be able to do it via scripting, I would not suggest that approach (using source.field_name and querying cmdb_ci_computer using GlideRecord and updating).

 

Thanks and regards,

Subrahmanyam Satti

0 Helpfuls