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 tables like Apache web server stopping other discovery sources to update fields on those tables

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.

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

Out of the box (OOB), there are a total of 388 reconciliation rules for ServiceNow and ServiceWatch Discovery Source. These reconciliation rules need to be removed.

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

Now decision is, ServiceNow 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(); }