The Zurich release has arrived! Interested in new features and functionalities? Click here for more

Can we Clone specific tables only? specifically Sys_user and sys_user_grmember table?

Cent
Tera Contributor

We are checking for the feasibility for cloning automation for sys_user and sys_user_grmember table. We also aim to exclude other user/accounts and to not clone deactivated users. 

Any approach for this or is this feasible?

9 REPLIES 9

Cent
Tera Contributor

hi @Bhuvan

i think those exclude/preservers from system clone can work fine as to my requirement no?

@Cent 

 

Yes, you can use exclude and preservers as per your requirement. Refer below for more details,

 

https://www.servicenow.com/community/developer-forum/difference-between-preserve-and-exclude-data/m-...

 

ServiceNow has exclude blacklist during clone and even if you have selected excludes, system might still clone it. You can refer the details in FAQ link I shared.

 

If this helped to answer your query, please mark it helpful & accept the solution. 

 

Thanks,

Bhuvan

@Cent 

 

Did you get a chance to review this ?

 

If my response helped to answer your query, please mark it helpful & accept the solution.

 

Thanks,

Bhuvan

Ankur Bawiskar
Tera Patron
Tera Patron

@Cent 

you can use Clone Exclusion and Preserver

Understanding the Difference Between “Preserve” and “Exclude” Data in ServiceNow Cloning 

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Shashank_Jain
Kilo Sage

@Cent ,

 

Please go through this artice it will be helpful - 

https://www.servicenow.com/community/upgrades-and-patching-forum/article-servicenow-clone-made-easy-...

 

Answer to your question :

  • Yes, you can clone only sys_user.

  • But be careful: references to roles, groups, and workflows may break if related tables aren’t cloned.

  • For selective active users only, scripted export/import is safer than table clone.

Hope it helps!

 

 

 

If this works, please mark it as helpful/accepted — it keeps me motivated and helps others find solutions.
Shashank Jain