List of suggested Exclude Tables and Preserve Data for cloning for SSO

[MWright1]

This is a Re-post to the Developer forum from Admin...  in case I should have posted here instead...

https://www.servicenow.com/community/sysadmin-forum/list-of-suggested-exclude-tables-and-preserve-da...

-------------

Hi all,

I have searched high and low for this and cannot find any direct answer. The closest I got was a link posted by Aaron that no longer exists:

http://www.cloudsherpas.com/servicenow-implementation/servicenow-admin-101-system-clones-best-practi...

We use SSO on PROD and I am under the impression that if we clone to a TEST instance, the login method will become the same as PROD and therefore mess it all up.  Basically, we need to prevent SSO properties from getting cloned and overwritten.

I know I need to create Preserve Data in the target instance.  I have the list of the tables to preserve the Users:

sys_user
sys_user_role
sys_user_group
sys_user_grmember
sys_user_has_role
sys_group_has_role
sys_user_role_contains

What I am asking for is a list of tables I need to create in Preserve Data in the TEST instance to preserve SSO...  any help is highly appreciated.

[MWright1]

Hi sorry... did you mean the sys_properties?  I can't find a sso_properties table...  Thanks again.

[Mark Endsley]

type sso_properties.list in the filter navigator, it should open a table.

[MWright1]

Got it!  Thanks!  It's actually already pre-included, we just can't see it.

[frankflanagan]

For anyone finding this thread in 2024, here is the current version of the answer:

https://docs.servicenow.com/bundle/washingtondc-platform-administration/page/administer/managing-dat...