Sync user/group/roles data from PROD to lower instances

[Tejal Patil1]

Hello Everyone,

I need to synchronize user, group, and role data from our Production instance to our Dev and Test instances. Specifically, when a user, group, or role record is created in Production, it should also be created in the Dev and Test instances.

I attempted to achieve this using REST integration; however, this approach is causing issues with sysid mismatches. When a record is created in Production and then replicated to Development/Test instances using the REST POST method, it is assigned a different sysid in those instances. I've learned that any integration or transform map may lead to sysid conflicts, so this approach isn't feasible.

I am aware that the IDR (Instance Data Replication) plugin can replicate data but it is paid and is not recommended for system tables such as user, group, and role records. Since we need to automate this process, a manual import/export approach is not suitable.

Could anyone suggest an alternative method to automate this synchronization?

Thank you.

[Tejal Patil1 · Accepted solution]

This requirement can be fulfilled using the paid ServiceNow Remote Instance Spoke. Once the proper connection is established, records can be created in lower instances. We encountered a sys_id issue, which we addressed by making necessary customizations in the transform map.