Compare table data between two servicenow instances

[Community Alums]

I want to compare table data between two servicenow instance say prod and stage instances , generate a list with the coulmn endpoint from prod n stage table and additional column say either match or notmatching based on the output.

Kindly suggest your ideas or ways how can we compare between two instance

Please help

[Tony Chatfield1]

Hi, you could export both tables to excel or sql and then run field comparisons.

Or if you are more comfortable with javascript, perhaps import one instance data into a temp import table (in the other instance) and then script a comparison check.

Can you clarify why you need to compare the 2?

[Community Alums]

What you could also try is the browser plugin called "SwissNow". Among other great features, it allows you to compare data between different instances.

[Indrajit]

Hey anusha,

follow the below link which gives step by step solution.

https://mr.spoc.pl/comparing-servicenow-tables-in-two-instances-step-by-step/?lang=en

or can refer,

https://docs.servicenow.com/bundle/orlando-application-development/page/build/team-development/task/...

mark Correct and Helpful if it applicable to you.

Regards,

Indrajit