How to Prevent duplicates on cmdb_health_result table using identification rules

Priya60
Tera Contributor

‎10-28-2024 11:52 PM - edited ‎10-28-2024 11:55 PM

I have same names for "Business Service(cmdb_ci_service)" table and "Technical(cmdb_ci_service_technical)" table records. Because of this it is creating duplicate tasks in cmdb_health_result table. But we will be retiring(install_status = Retired) for "Business Service(cmdb_ci_service)" table records. Install_status is taken from choce(sys_choice) table on respective tables. I have added condition not to take "Retired" status in the identification rule for both the tables. But it is taking the condition independently on each table and showing all of those records as duplicates.

How to add identification rule to take combination of 'Name+install_status' to avoid duplicate entries CMDB Health Result table. Please suggest.

Priya60_0-1730184321234.png

 

0 Helpfuls
  • 498 Views
1 REPLY 1

Abbas_5
Tera Sage
Tera Sage

‎10-30-2024 11:35 PM

Hello @Priya60,

Please refer to the below steps or link:

To prevent duplicate records in the CMDB Health result table in ServiceNow, you can use the Identification and Reconciliation Engine (IRE) to identify and flag duplicate CIs:
  1. Run discovery
  2. Run any custom scripts or import engine that calls IRE 
     
The IRE will create duplicate tasks and flag duplicate CIs. To remediate duplicate tasks, navigate to Configuration > Identification/Reconciliation > De-duplication Tasks. 
If all records are checked, the duplicate metric job can take a long time and require a lot of resources. 
 
https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0712338
 

If it is helpful, please mark it as helpful and accept the correct solution. In future, it might be helpful for someone to refer to this solution.
Thanks & Regards,
Abbas Shaik
0 Helpfuls