Create a Custom coalesce Field instead of Using the Correlation ID Field

1. Log in to ServiceNow as admin.

2. Under System Definition locate and click Tables.
3. Filter on Name to find the cmdb_ci table.
4. Add a custom field as String, with the value of 100 as Max length.
5. Click Update to save and quit.

The Created field will be starting with a prefix to isolate it from OOTB ServiceNow fields, and avoid collisions during upgrades.

The next step consists of making sure that the staging tables have the created custom field. There are different scenarios at this point:

• If you are creating an import set as described in Create Inbound Services for Class Models, the custom field will be automatically in the staging table while using the Copy fields from target table feature.
• If you are using the OOTB Update set that comes with the connector. You must update the Inbound Services by adding the custom field and change the mapping by removing the Correlation ID mapping and replace it by the custom field mapping.

1. Log in to ServiceNow as admin.
2. Under System Web Services > Inbound, locate and click the inbound service you need to update.
3. Scroll down the list of Web services fields, and double click Insert a new row.
4. Populate the label and make sure the name is identical to the custom field you created in the Configuration Item table.
5. Delete the Correlation ID field from the Inbound Service to avoid having it mapped using the auto map matching field during the creation of the Transform Map.

1. Log in to ServiceNow as admin.

2. Under System Import Sets > Administration, click Transform Maps.

3. Locate and click the transform map to update.

4. If you are using the OOTB Update set or you created a mapping for the Correlation ID. You must locate and remove the Correlation ID mapping row from the Field Maps tab.

5. To delete a row, check the box and scroll down to the Action on the selected row choice list, and then select Delete.

6. Check if the created custom field is mapped correctly to the target table after using the Auto map matching fields feature. If you did not use this feature after creating the custom field, then you have to add the row manually either by:

   • clicking Auto map matching fields, or,

     Note: Make sure that Correlation ID was not left in the Inbound Service or just remove it from the mapping afterward.
   • use the map assist from the related links to add only the created custom field.

   

7. Set the Created custom attribute as coalesce field.

1. Open the push or population XML mapping file of your interest.

2. For each CI in the mapping file, map its UCMDB global_id value to the custom field instead of the correlation_id field.

1. Open the adapter.properties configuration file.

2. Set the class.model.coalescce.field property to the name of the custom field in ServiceNow.