<style>
.release-box {
	height: 30px; 
	width: 100px; 
	padding-top: 8px;
	text-align: center; 
	border-radius: 5px; 
	font-weight: bold; 
	background-color: #d4af37;  
	border-color: #FCE28A;
}

.release-box:hover {
  	cursor: hand;
    cursor: pointer;
    opacity: .9; 
}
</style>
<meta name="robots" content="noindex">

<div class="release-box">
<a href="https://docs.perspectium.com/display/gold" style="text-decoration: none; color: #FFFFFF; display: block;">
Gold
</a>
</div>



Procedure

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



Access table compare 

In your ServiceNow instance, go to Perspectium > Replicator > Tools. In the Tools page, select 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.




Update Row Counts

Update Row Counts will run a query to see the number of records for this table in the local instance as well as the number of records in the target instance. After the query has completed, the Local Record Count and Target Record Count fields will be updated with the respective number of rows found in each instance for this table.

This option allows you to see if the tables match up in terms of the number of records. If they do not, you can use the Compare Rows option for more detail on the discrepancies.


Compare Rows

Compare Rows will go through and see which sys_ids exist in the local instance but do not exist in the target instance and vice versa. Because some tables can be rather large, this feature will run in the background as a scheduled job and the Compare Rows Status field will show the status from when the job is scheduled (after clicking Compare Rows to start it) to when it is running in the background to completed when it has finished processing all the rows of the table both on the local instance and the target instance.

The Compare Rows Started and Compare Rows Completed fields will provide the date and time when the scheduled job starts and completes. You will need to reload this form in order to see changes in the Compare Rows fields with its results and as mentioned for large tables, it is recommend you check back later to give it to time to run the comparison (for example, a test of 150,000 records took about 25 minutes to complete).

For cases where there are discrepancies the Compare Rows Status field will show a status of Completed with Discrepancies and the records that are missing in either instance will be listed in the PSP Row Discrepancies table found at the bottom of the page. For those sys_ids that exist in the local instance and do not exist in the target instance, the sys_id will be listed with a state of Missing in target. The sys_ids that do not exist in the local instance but exist in the target instance will be listed with a state of Missing locally.



Similar topics

Contact Perspectium Support

US: 1 888 620 8880

UK: 44 208 068 5953

support@perspectium.com