Request a clone：Preserve Users and related tables

[Tepp]

Hi,

Which table is a user-related table in the clone request option?

Preserve Users and related tables：Prevents Users and user-related tables from being overwritten on the target clone.

https://docs.servicenow.com/bundle/madrid-platform-administration/page/administer/managing-data/task...

best regards,

[Ct111]

Check the users table and in that which ever are the reference fields that will be related  tables.

Mark my Answer as Correct n Helpful if it helped

[Chris H2]

Hi creativethinker,

I'd be amazed If that were true. There are over 1,000 tables with fields referencing the sys_user table, including task and cmdb_ci. Surely these aren't ALL preserved?

Kind regards,

Chris

[Andre Kosak]

I'm wondering with the same thoughts.

[Chris H2 · Accepted solution]

Hi all,

I raised a HI case with ServiceNow to ask this exact question. It turns out these conditional table preservations are hardcoded i.e. won't show up in your Preserve Data list. These are the tables preserved when that tick-box is ticked:

User (sys_user)
User Role (sys_user_has_role)
Role (sys_user_role)
Group Member (sys_user_grmember)
Group (sys_user_group)

If, like me, you prefer user changes to propagate to sub-production instances, you can update the default value of the Dictionary Entry of this field to false, so this option is unticked by default for new clones.

I hope this helps - please mark my answer as correct and helpful as appropriate.

Best regards,

Chris