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.
Select the Module – Compare Tables
2. Create a new comparison:
A. Click the “Compare tables” module, a new page will appear:
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.
C. Fill fields with names and credentials to the remote instance you want to compare against.
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)
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:
3a. 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.