Clone user and user group tables from PROD to Lower Instance using scheduled job to run weekly

JMD FAROOQ
Tera Contributor

How to clone sys_user and sys_user_group table from prod to lower instance using scheduled jobs ? so that we can run it weekly.

5 REPLIES 5

Mark Manders
Mega Patron

You could use IDR: https://docs.servicenow.com/bundle/vancouver-servicenow-platform/page/administer/instance-data-repli...

 


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

Hi Mark,

 

I tried IDR, but since it is a subscription-based plugin, it does not fall under our client license. Do you have any other alternate suggestions?

You could build an integration for this between your instances. Or just do it manually. It's just two tables.


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

The client needs this task to be done regularly every week, so doing it manually is not what they want. Can you provide more details about the integration you mentioned? It would be helpful for my understanding if you could provide an example.