How to Create a CI from an existing asset?

Teri Bobst
Mega Guru

Hi Community, we had a data import during our Asset implementation that created the Asset records without creating the corresponding CI's. This was related to bad mapping on the model information and has since been corrected so all new imports work as intended.

My question - how can I go back to the 100 or so asset records that do not have CI's and force the creation of the CI? Is there a simple way to do this, or would it be best for me to just delete the assets and re-import all of them?

Thanks,

Teri

5 REPLIES 5

akash_mehta
ServiceNow Employee
ServiceNow Employee

Teri:   I believe what you could do also is export those CI records with a unique value (serial number I presume) and import them back in via a transform map.



1)   Target table - alm_hardware


2)   Coalesce - Serial Number


3)   Map the CI reference field - Set


4)   Map any other asset related fields that you need



This should create the asset (because it doesn't exist) and associate the existing CI to the asset (without creating a new one).   In the business rule that creates the CI, there is a condition where CI is not NULL...so I am hoping that associating the CI at time of creation will work.



Thanks,


Akash