Bulk Update Assets through CSV

[Richard22]

Hello community, I have recently taken over Asset Management at my company as part of ServiceNow Asset Management and we have a massive project tp update existing asset data. I was able to easily enough create transform maps and import assets, however after an audit, we found many assets did not have users assigned, correct Serial Numbers, Locations or Primary Functions. This audit included about 3,000 computers, we cross referenced multiple systems and gathered all the "Correct" data into a spreadsheet. At this point, we need to update almost 2,800 computers, but not insert new devices as Discovery & an SCCM integration have added valuable data such as software installations and network mapping.

When I attempted to run an transform/import, it created brand new assets, even if Device Names or Serial Numbers already existed.

My questions is this, does anyone know of an easy way to bulk update assets without creating new items in ServiceNow? Every attempt I have made in our DEV instance is creating new records rather than updating existing.

[Sulabh Garg · Accepted solution]

Hi Richard,

You need to define the coalesce field as "Serial number" (or other field which is unique) in transform maps to avoid creating records instead of updates.

For more information on coalesce field set up in transform maps.

Please visit this docs link.

Please Mark ✅ Correct/helpful, if applicable, Thanks!! 
Regards
Sulabh Garg

[Richard22]

Hello Sulabh, 

I appreciate the quick response, I was doing this, however, after your answer, I took another look, it seems ServiceNow may be case sensitive. Our external reports showed all devices in lower-case for Hostnames & Serial Numbers. I made all capital and the import worked and all records needing updates were updated. 

Your answer was correct, so thank you for replying and getting me on the right track to make sure I wasn't crazy!