Hello, We are facing an issue with duplicate instance records within the MSSQL server instance records. We've recently started development on MSSQL Discovery to populate some additional information and to get AG, mirroring databases, clusters etc. For that, we've built a new probe and sensor with the help of Powershell script from DBA team and disabled the out of the box probe, sensor and classifier. Everything is working as expected like creating an instance with all the desired data, related catalogs and etc. But, here is an issue coming up with inserting records on CMDB. We already have some existing instance records in the CMDB instance table, when we run the Discovery, in some cases it creates a new empty record just with the instance name instead of updating the older one. In some case it updates the old one but creates the new record. In some cases if there multiple records for the same instance it either updates one record or doesn't updates both records, creates new record with updated information. We've also created a Business rule to update the older record if it finds the existing record with the same instance name else to create a new record. It worked in the beginning but when we started to test different servers it was still creating duplicates. can anyone help me with the troubleshooting to solve this issue. Thank you!
