Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Prerequisites


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

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

(warning) Then Lastlyset your initial Perspectium & DataSync properties.

Procedure

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


UI Steps


UI Step

Access table compare 

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

Image Removed

to Database.

Then, click Legacy Table Compare.

Example below is for Table Compare: ServiceNow to ServiceNow.

Image AddedExample below is for Table Compare: ServiceNow to Database.

Image Added



UI Step

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.


UI Step

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