---
sourceDocument: Zurich ServiceNow AI Platform Capabilities
sourceDocumentLink: https://www.servicenow.com/docs/r/zurich/servicenow-platform

 Release :

    - zurich

ft:locale :

    - en-US

ft:publication_title :

    - Zurich ServiceNow AI Platform Capabilities

ft:clusterId :

    - platcap

bundleId :

    - platcap

workflow :

    - Platform


---

# Find missing or mismatched records

# Find missing or mismatched records in Instance Data Replication {#ariaid-title1}

* Release version: Zurich
* 
* Updated July 31, 2025
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 2 minutes to read

Find records missing from the consumer instance or mismatched records after data has been replicated by creating a data comparison request in Instance Data Replication (IDR).

## Before you begin

Make sure the following conditions are met:

* The producer replication set is active.
* Seeding isn't in progress.
* No other data comparison requests are running.
{#compare-replicated-data__ul_hfh_sxc_dxb}

Role required: admin

## About this task

Note the following:

* Data comparison requests are purged after three months.
* There are limitations when comparing transformed data. See [Comparing replicated data between instances in Instance Data Replication](https://www.servicenow.com/docs/ZwBxZE8EjVPFz7VN4nDp_g "Find missing or mismatched records by comparing replication data between instances in Instance Data Replication (IDR).").
{#compare-replicated-data__ul_ocd_kjd_dxb}

## Procedure

1. On the producer instance, navigate to AllInstance Data ReplicationProducer Replication Sets.
2. Select an active producer replication set with replicated data that you want to compare.
3. Create a data comparison request.
   1. Navigate to the IDR Data Comparison Requests related list.
   2. Select New.
   3. On the form, fill in the fields.  
      {#compare-replicated-data__table_ipd_2mq_1xb__entry__2}

      | Field | Description |
      |-|-|
      | Replication Set | Name of the producer replication set. |
      | Target Instance Name | Name of the consumer instance. |
      | Target Instance URL | URL of the consumer instance. |
      | Table Name | Name of the table in the outbound entry of the producer replication set. |
      | Start Date | Start date and time for comparing data. Records with a sys_updated_on value after the date you select are included in the comparison. |
      | End Date | End date and time for comparing data. Records with a sys_updated_on value before the date you select are included in the comparison. |
      | Auto Seed | Option to automatically seed any missing or mismatched records from the producer instance to the consumer instance. You can optionally reseed missing or mismatched records at a later time. See [Reseed missing or mismatched records in Instance Data Replication](https://www.servicenow.com/docs/lyvK6mt3WhL0j5zzJ~t3LQ "Synchronize data between instances by reseeding records missing from the consumer instance or mismatched records between the producer and consumer instance in Instance Data Replication (IDR)."). |
      [Table 1. IDR Data Comparison Request form]

      {#compare-replicated-data__table_ipd_2mq_1xb}
   4. Select Submit.
   {#compare-replicated-data__substeps_vr2_lkq_1xb}
4. View a summary of the data comparison in the IDR Data Comparison Results form.
   * Determine the percentage of missing or mismatched by viewing the pie chart.
   * View the total number of missing and mismatched records in the Mismatched Records Count field.
   {#compare-replicated-data__choices_j4z_rgx_1xb}
5. **Optional:** Identify records that are missing from the consumer instance after seeding through the pie chart or list.
   * View the missing records by selecting the missing records portion of the pie chart.
   * View records that have a Missing value in the Record Type column in the IDR Instance Comparison Results related list.

   {#compare-replicated-data__choices_ntx_hrd_dxb}  
   Tip:  
   Save copies of the missing record IDs in case you need to provide them to Customer Service and Support.
6. **Optional:** View the differences between mismatched records after data replication.
   1. Navigate to the IDR Instance Comparison Results related list.
   2. Select the check box next to any record with a Mismatched value in the Record Type column.
   3. Select the Actions on selected rows list.
   4. Select Compare records.
   5. View the highlighted differences between the records in the Compare Record Payloads dialog box.  
      Note:  
      Journal fields are excluded from the comparison due to the potential size of their content.
      Save a copy of the payload difference in case you need to provide it to Customer Service and Support.
   {#compare-replicated-data__substeps_vqw_t3x_1xb}

## What to do next

[Reseed missing or mismatched records in Instance Data Replication](https://www.servicenow.com/docs/lyvK6mt3WhL0j5zzJ~t3LQ "Synchronize data between instances by reseeding records missing from the consumer instance or mismatched records between the producer and consumer instance in Instance Data Replication (IDR).").

*[\>]: and then