Step by Step – Comparing Tables on Two ServiceNow Instances

This application is designed to quickly find differences between two ServiceNow instances, i.e. Production and the QA.

Example Use Case

When developing functionality in ServiceNow, it’s best practice to create something in the development environment, test it and then move it to production. An ideal scenario would be via a dedicated instance for Quality Assurance.

When completing the transition between instances, we use Update Sets to capture all of the changes. Typically this goes without issue but sometimes some functionality isn’t moved.

When this happens, it can be a time consuming and difficult task to determine exactly what has and hasn’t been moved.

In response to this challenge, we have a dedicated application to cross-reference and compare two tables from separate instances.

Below, is a step-by-step breakdown of how simple this is to complete.

  1. Select the Module – Compare Tables

Select Module

2.  Create a new comparison:

A. Click the “Compare tables” module, a new page will appear:

Create a new comparison in ServiceNow

B. Start writing the table name you want to compare. The field will auto-complete and input the table name based on the local instance tables stored in Tables [sys_db_object] HOWEVER you can input any name you want.

Select Table

C. Fill fields with names and credentials to the remote instance you want to compare against.

Select Instance & Table

D. Use the “Run as an asynch job” if you predict that the transaction will take too long and would be interrupted by ServiceNow.
E. Use the “sysparm_query=” field to compare all records not (encoded with the query syntax)

ServiceNow Sysparm_query

F. Click the “OK” button to compare

Comparing ServiceNow Tables 

3. New “Compared tables set” will be created with the “Compared records” related to it:

Compared Tables

3a. Record Comparison

ServiceNow Record Comparison

If you would like to find out more about this article and have a question for SPOC, please get in touch and reference this article.