Excluding records from clone

[Maria DeLaCruz]

Hi,

We have some confidential records in the dmn_demand table that are only accessible by users with a certain role.  When we clone production over to our sub-production environment, we would like these records to be excluded because our ITIL users have the impersonator role in our sub-production environment.  We want to prevent users from impersonating someone with access to the confidential records.  Any assistance would be greatly appreciated.

Thanks,
Maria

[Boyan1 · Accepted solution]

Hello, 

There are two options available:

1. Exclude the dmn_demand table from cloning. For further details, please check here:

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

2. Add Post-clone cleanup script that will delete the  confidential records from the dmn_demand after cloning is complete. For further details, please check here:

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

Let me know in case you have any questions.

Best regards,

Boyan

[Maria DeLaCruz]

Thanks Boyan!  We do not want to exclude the entire dmn_demand table, so we'll try the post-clone cleanup script.

[Maria DeLaCruz]

Hi Boyan,

We had our sub-production instance cloned yesterday, and the post-clone cleanup script worked successfully.  None of the confidential records got copied over from production.  Thanks so much for your help!

Maria