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

[Cent]

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?

[Rafael Batistot]

Hi @Cent 

As directly answer in ServiceNow, the out-of-the-box Clone feature does not allow cloning specific tables only it is always a full instance clone (all data, configs, and customizations are copied from source to target).

[Cent]

Hi @Rafael Batistot ,

Thank you for your response, in that case i cannot do cloning lets say only sys_user table. i cant clone sys_user table only to other instances?

[Rafael Batistot]

@Cent 

Nop. I don’t know what your porpoise but if you want to “clone” those table to other instances, is better you export with xml format, all data, and import in other one

See reference 

Key benefits

• Directly export records as XML from any list or form.
• Transfer all fields and values exactly from one instance to another.
• Perform unscheduled data imports as needed.
• Save time by not building import sets or transform maps.

https://www.servicenow.com/docs/bundle/zurich-platform-administration/page/administer/development-be...

[Bhuvan]

@Cent 

You do not have option of inclusion but you can exclude tables to be cloned. Refer below useful links and FAQs for cloning,

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB1214608

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0715621

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB1214621

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

Thanks,

Bhuvan