Prerequisites


(warning) First, you will need to request the update set for Legacy Table Compare.

(warning) Then, you will need to install DataSync for ServiceNow and the Legacy Table Compare, then run the Perspectium Finish Install scripts.

(warning) Lastly, set your initial Perspectium & DataSync properties.

Procedure

To set up table compare for two ServiceNow instances, follow these steps: 

Access table compare 

In your ServiceNow instance, go to Perspectium > Perspectium Core > Tools. In the Tools page, select Table Compare: ServiceNow to ServiceNow.

Then, click Legacy Table Compare.

Example below is for Table Compare: ServiceNow to ServiceNow.

Create table compare 

Click New. Then, fill in the following fields: 

  • Table Name: The table you want to compare.
  • Target Instance URL: The URL of the remote (target) ServiceNow instance you to compare the table with.
  • Target Instance User: A user who has access to the instance specified in Target Instance URL. This user requires the admin role in the target instance in order to be able to properly access the table and its data.
  • Target Instance Password: The password for the target instance user.
  • (Optional) Conditions: Any filter conditions to use when comparing the table. This feature is similar to adding filter conditions on a table's list view in ServiceNow or in the dynamic share and bulk share options. For example, if you want to see how many records are in the table in both instances created in the last three months, you can add the filter condition here.

All other fields on this form are used by the table compare feature to display results when running its options.

Click Submit when you're all done.

Use table compare

Start comparing your local instance to a target instance with the options listed below: 

Update Row Counts

Compare Rows

Import Missing Records Locally