How do I reconcile a CI that is discovered with data from a Spreadshet?

[syddent]

Hello

I am trying to reconcile data from two sources into one record in the CMDB. I am working in Geneva

I have a set of discovered CIs using ServiceNow Discovery

I have a spread sheet of CI data with matching names and serial numbers with cost data that I wish to merge into the CMDB record

I created a CI Identifier for the class

I then created a Reconciliation Definition

I created a Datasource Precedence

I created the import set to bring in the data (with appropriate mappings). Below is the data I brought in

This is what I ended up with

You will notice two CIs with the same names. The ones with the OS are the records created by ServiceNow Discovery. The records without an OS are from my spreadsheet.

So what am I missing in this process? Why was my Reconciliation Definition not executed?

Regards,

Sydney Dent

[jake_mckenna · Accepted solution]

Unfortunately it is not that simple when working with Transform maps. Identification and reconciliation components and process utilize the API that come with this process. Today the transforms do not automatically go through this process and you would need to build something in your transforms instead of this.

Check out the ServiceNow Developers site on how to pass information into the CreateUpdate() api and also review the script include CMDBTransformUtil() as it has some useful methods to help with this process change.

**Just make sure any row is ignored in your transform is ignored as you would not want to process it twice!