Reconciliation rules(ServiceNow, ServiceWatch) on multiple table like Apache web server stopping other discovery source to update fields on those tables - Known Error

Reconciliation rules(ServiceNow, ServiceWatch) on multiple table like Apache web server stopping other discovery source to update fields on those tables Description Reconciliation rules(ServiceNow, ServiceWatch) on multiple table like Apache web server stopping other discovery source to update fields on those tables

Install Service graph connector for Dynatrace or any other product plugin Insert a record in Apache web server table try to update any field on that record again using SGO-Dynatrace It is dropping update because of reconciliation of Servicewatch and ServiceNow There are around 300 tables with these reconciliation rules.

Steps to Reproduce

Install Service graph connector for Dynatrace or any other product plugin Insert a record in Apache web server table try to update any field on that record again using SGO-Dynatrace It is dropping update because of reconciliation of Servicewatch and ServiceNow

There are around 300 tables with these reconciliation rules.

Screenshot 2023-09-08 at 3.01.11 PM.png

Workaround Issue : Reconciliation rules(ServiceNow, ServiceWatch) on multiple table like Apache web server stopping other discovery source to update fields on those tables

In OOB we have 388 total Reconciliation rules for ServiceNow and ServiceWatch Discovery Source, we need to remove all this Reconciliation rules,

We run Audit script for Reconciliation Definition table, some customer delete these rules, some customer keep these rules and some customers add more rule

Here attached Audit script result

Now decision is, we will not remove OOB Reconciliation rules for ServiceNow and ServiceWatch Discovery Source, reason is some customer delete these rules, some customer keep these rules and some customers add more rule, it may impact to some customer

if any customer want to remove this OOB Reconciliation rules for ServiceNow and ServiceWatch Discovery Source, run below script in System Definition - Scripts - Background

For checking the Reconciliation rules for ServiceNow and ServiceWatch Discovery Source count :-

getServiceWatchReconciliationCount(); // Total Records in ServiceWatch Reconciliation Definition table getServiceNowReconciliationCount(); // Total Records in ServiceNow Reconciliation Definition table

function getServiceWatchReconciliationCount() { var gr = new GlideRecord('cmdb_reconciliation_definition') gr.addQuery('discovery_source', 'ServiceWatch'); gr.query(); gs.info("Total Records in ServiceWatch Reconciliation Definition table: " + gr.getRowCount()); }

function getServiceNowReconciliationCount() { var gr = new GlideRecord('cmdb_reconciliation_definition') gr.addQuery('discovery_source', 'ServiceNow'); gr.query(); gs.info("Total Records in ServiceNow Reconciliation Definition table: " + gr.getRowCount()); }

For Removing the Reconciliation rules for ServiceNow and ServiceWatch Discovery Source :-

Note : Run Below query In Global Scope

deleteServiceWatchReconciliationrules(); // delete Reconciliation rules for ServiceWatch datasource deleteServiceNowReconciliationrules(); // delete Reconciliation rules for ServiceNow datasource

function deleteServiceWatchReconciliationrules() { var gr = new GlideRecord('cmdb_reconciliation_definition') gr.addQuery('discovery_source', 'ServiceWatch'); gr.query(); gr.deleteMultiple(); }

function deleteServiceNowReconciliationrules() { var gr = new GlideRecord('cmdb_reconciliation_definition') gr.addQuery('discovery_source', 'ServiceNow'); gr.query(); gr.deleteMultiple(); }