Service Graph SCCM Connector - when no asset tag from import default to Serial

[Mel Saligumba]

After the imports many assets show their asset tags as "default string" or empty.  How can we default these assets to show the serial numbers when there are no valid asset tags?

[#2 · Accepted solution]

You could create a business rule that fires before insert/update.  The condition would be where asset_tag is empty or "default string" and the script would set the asset_tag to the serial_number.  Something similar to the following.

[Arijit Gupta1]

Also ,

1. You can use the Script field to set the correct target value in a transform map .

2. Use the Script checkbox inside a field map to return the correct target value .

[Donald11]

Hello, we are running Service Manager 2010 SP1, CU3.  We are having an issue with the SCCM connector; it is not importing the serial number into SCSM.  We have opened the objects in question in SCCM and confirmed the serial number is present there, but when opening the same object in SCSM the serial number is missing (same appears to be true for the Asset Tag field as well)

MyFordBenefits

[rambabuboyapati]

Add a transform map (Transform Type = Script Operation) in IntegrationHub ETL for Asset Tag, using the below docummentation.

Create an ETL transform map | ServiceNow Docs