Issue in the importing of user records from Prod to Uat instance

[DASAMANDAMS]

We need some suggestions regarding data synchronization between our UAT and Prod instances in ServiceNow (sys_user)table.

Currently, we have around 50,000 users with mismatched data between the UAT and Prod instances. We run a weekly scheduled job to import users into the UAT instance. However, since some users were already created earlier in UAT, the user data between Prod and UAT is not fully aligned.

Additionally, we are unable to delete the existing UAT users and rerun the scheduled job, as the job does not support a full data load due to the large volume of records. The same limitation applies when attempting to use XML export/import.

Our goal is to synchronize the user records in UAT with those in Prod.

Could you please suggest the best approach to handle this situation?

also I would like to know:

Is it possible to clone only the sys_user table from Prod to UAT?

If yes, could you please guide us on the process for performing a partial clone? I dont want full clone

Alternatively, if there are any other recommended methods to effectively synchronize the user records, we would appreciate your suggestions.

Thank you in advance for your guidance.

[GlideFather]

Hi @DASAMANDAMS,

yes, it is possible to clone just some data (e.g. Users).

Read more: 

KB0715621 | Clone FAQs - Frequently Asked Questions

KB1214608 | Clone Basics

ServiceNow Cloning preparations and best practices Article/ Blog

KB0717012 Clone results based on Exclusion and Preserver configuration

Or for any data operations, usually when they are lost but perhaps it's applicable for this case as well, you can reach out to ServiceNow from Support portal, they can create a temporary instance where you can get all your data prepared and once you know it's all good, then you clone the instance with the data already in place. After that the temporary instance is reclaimed.

Why don't you backup development in progress/in testing and clone over the whole UAT from production? Or to schedule it. Usually the UAT data are anonymised due to the access restrictions (e.g. contractors or vendors) can basically see production data, be careful about moving all the users there, is it really necessary???

The approach as seen above is usually for production data and I don't know if this can be done for UAT environment as well...

I would delete all the UAT users and import from production by smaller chunks (e.g. by 5000 or by 10000), but also be aware that user records are full of references (e.g. Location) so the export files might be massively large!

I believe that asking ServiceNow via case could be also the way.