Duplicate records is getting created for one of the ip switches while auto discovery.

[Shraddha Dube]

Duplicate records is getting created for one of the ip switches while auto discovery.

Example: there 4 to 5 records showing created by specific same mid server in ServiceNow discovery. Both are having same Host Name but only one is showing ip address while other is showing empty field also showing like duplicates of that particular Server which is showing IP address 

May I know how and where to start and fix this duplicate entry creation issue in CMDB.

Thank you in advance!!

[Mark Manders]

Check the patterns you have in there. Check the reconciliation rules. Check errors in your import. If you are saying 'host name and ip address need to be unique' and one is getting in without an IP, you will get a duplicate.

[ravitejamal]

Hi @Mark Manders ,

There are three CIs and one is main CI with IP address and other two are created without an IP address.

I have attached the Identification rule screenshot, could you please help us to understand what cause might have to create the duplicate CIs.

[SK Chand Basha]

Hi @Shraddha Dube 

Is those are stacked switches? 

If it is stacked switches two records will be created in servicenow, where stack mode indiactes whether those are stacked or not. 

If not please check the IRE rules on IP Switch table. 

Mark it helpful and Accept Solution!! If this helps you to understand. 

[Sohail Khilji]

HI @Shraddha Dube ,

Check you IRE to see which field is included as primary key, Go to serial_number table and delete the duplicate serial number recors if any ?

If the Serial number does not match, then it will always execute the first identification rule and create a new CI. Find the diffrence between the 2 records on its created date, updated data , discovery source etc..