Clone and Exclude users in [sys_user] with class = contact OR class = consumer user

[HH10]

Clone instance and exclude users in [sys_user] with class = contact OR class = consumer user

[ersureshbe]

Hi,

Do you have CSM module in your business. If yes you should exclude users in sys_user and customer_contact table.

Your business holds the consumer then you should exclude the consumer table as well.

Please mark as correct if it helped.

Regards,

Suresh.

[HH10]

Instead of excluding the whole [sys_user] table, is there a way to exclude ONLY the records for CSM? We have a department who wants to keep the CSM data in both [customer_contact] and [sys_user] table only in our Production instance.

[ersureshbe]

Hi,

Can you refer below link about preserve data procedure.

https://finite-partners.com/servicenow-clone-data-preserver-what-is-it-and-why-do-i-care/

For safer side, you should act below steps.

The pre cloneing steps the following performed by your end. Take a XML file for data backup for the following table.

1. sys_user

2. customer_contact

3. customer_account

4. core_company

5. Account relationship from CSM.

[HH10]

What table is this?

5. Account relationship from CSM.

What I am did so far are:

• Add the following to the exclude table: [sys_user], [customer_contact], [core_company], [customer_account]

Should I add these tables too on the Preserve Data? or should I import the exported XML with the non CSM data on [sys_user] and [core_company]?