Updating CI information with excel upload.

Craig-Au
Tera Contributor

I have Virtual servers in my CMDB and I need to update some of the information in them. Is there a way I can do an Import from excel that rather than creating new Cis will find the names of the servers and add the new data into the fields for them.

2 REPLIES 2

Tom Sienkiewicz
Mega Sage

Hi, yes if you intend to do an import from an excel file, you can do this via import sets (using the "Load Data" module). 

What is important is to run each record through the Identification&Reconciliation Engine (IRE) which is an OOTB mechanism to ensure proper CIs get created/updated, to avoid duplicates etc.

https://docs.servicenow.com/en-US/bundle/sandiego-servicenow-platform/page/product/configuration-man...

Damhoej
Giga Guru

When you do the load data from the excel sheet you set coalesce = true on the name field in the transform map.

Then it will update in stead of inserting when it find a match on name.