How to link cis to asset for old records

[sai bharath kas]

There are assets with no ci linkage and ci with no asset linkage but both of them having same serial number, we need to make sure both are linked.  What is the best and safest way to link those?

[SANDEEP DUTTA]

Hi @sai bharath kas ,

There are two ways, Either you have do it Manually one by one.

Secondly, Use this logic :

Solved: Automatic associate Asset and CI based on matching... - ServiceNow Community

[Ankur Bawiskar]

@sai bharath kas 

check these links for help

Automatic associate Asset and CI based on matching serial number 

CI's Created From Assets Are Missing the Serial Number in the CI's Name. 

Asset and CI Sync in ServiceNow: 

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Ankur Bawiskar]

@sai bharath kas 

Hope you are doing good.

Did my reply answer your question?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Pratiksha]

Hi @sai bharath kas ,

Their are many reasons this might be happening. 

• No Model Category exists for the CI Class: A Model Category record specific to the CI Class/CI table must exist before any CI to Asset synchronization happens. Create a new Model Category record if it doesn't exist.
• Two Model Category records exist for the same CI Class: Delete all but the correct record.
• A Model Category exists, but with no Asset, table entered: Enter the correct Asset Class value and Save. Click the 'Create Assets' button to add the Asset records for all existing CI records of this CI Class.
• A Model Category exists, but with the wrong Asset table entered: Correct the Asset Class value. Update the Class value of some existing records to match the new setting.
• A Model Category, with an Asset table, but 'Enforce CI verification' is ticked: Untick 'Enforce CI verification' or open the specific CI and click the 'Create Asset' button.
• The Model of the CI is set to 'Don't create Assets': Change the 'Asset tracking strategy' field to 'Leave to the category' and manually create an Asset record.
• The 'Create Asset on insert' Business Rule, and dependent 'AssetandCI' Script Include maybe Inactive or Customised: Revert the business rule and script include to the current out-of-box version and re-implement any customizations using supported methods.
• The Asset is inserted, but values are empty: Check for ACL rules preventing creating assets, premature insert, or custom code running as part of the CI or Asset insert breaking the insert.

Go through this KB: https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0749624

Regards,

Pratiksha