How to judge the difference between PROD & Non- PROD instance ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-28-2015 06:13 AM
Greetings ALL,
I have 3 instances PROD, TEST, DEV.
DEV & PROD are in sync but TEST is not in sync with PROD. I have some SR's in TEST which are not on PROD. This is the only thing i know about the difference between both the instances.
Kindly help me out if there is way to judge what things i have in TEST and those are not available on PROD. Is there any mechanism to verify this?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-28-2015 06:31 AM
Hi Shikha,
You can write a script on production for all tables which is required for your test case and return the query in log. By this way you can get to know the exact count of related table record and same script run on the test environment and see the difference.
1. You will have to specify the more specific query on the table eg. date wise since production will have more records.
But i am not understanding your exact requirement. Its just silly things i believe but if you see mismatch in the data from the production.
Raise a hi request for cloning the test environment from the prod instance. All will be in sync.
Regards,
Atul Kumar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-28-2015 05:01 PM
You could query the clone_instance table (or navigate to the 'Clone History' module), which will give you a record of when the environments were last cloned and if they are 'in sync'.
ServiceNow Nerd
ServiceNow Developer MVP 2020-2022
ServiceNow Community MVP 2019-2022
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-28-2015 05:54 PM
Hi Shikha, you could use Team Development to identify those differences between Prod and Test. The following links should be helpful:
Using Team Development - ServiceNow Wiki
ServiceNow Team Development: Introduction - YouTube
Team Development - ServiceNow Wiki
Thanks,
Berny
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-28-2015 07:18 PM
Along with what Berny has suggested, you can also use the below method to check the difference.
type sys_update_xml.list in the navigation bar of the each instance.
It will open up all the "update records in the update sets".
Right click on header bar, click export to excel.
You will have many copies as that of your instances
Once done, sort these records in order of its name and compare those manually.
