How to set colesce field in CMDB Integration Studio Application Data source in servicenow

[Shantanu B]

Hi All,

We implemented Solarwinds integration with ServiceNow with help of Service Graph Connector.In Client environment CMDB, they have multiple CI with same serial number with different IP Address. When Import schedule will run, it is updating only one CI having same serial number. e.g 3 CI with same serial number 12345 having different IP address.

         OOB, I think Colesce on Serial number field. Can you please help on this issue?

Do I need to make IP Address also Colesce field. If Yes, How we can make it in CMDB Integration Studio Application Data source in servicenow.

Thanks in Advance!!!

[suvro]

Hi Shantanu,

Identification rules for hardware has 4 rules and based on order it checks for the serial number firstly. If it matches it updates the record.

So you need to modify the identification rule of the hardware table to check both serial number and IP address

[suvro]

Hi @Shantanu B 

If your query is resolved. Please mark my answer correct and close this thread. 

[Shantanu B]

Hi suvro,

I created new identification rule on Hardware table with attributes Serial number and IP Address, still it is updating single record in CMDB.