Updating CI information with excel upload.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-06-2022 06:37 AM
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-06-2022 06:47 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-07-2022 12:13 AM
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.