How to scramble confidential Production data when copying/cloning data to test instances

[ramandeepgarg6]

Dear Friends,

When data is cloned/copied from Production to Test instance then we want to scramble the data. For example we have a table "Issue" and we want to scramble "short Description" and "Description" fields of this table in test instance after cloning. Could you please tell how we can achieve this and what would be the best approach?

Regards

Ramandeep

[bernyalvarado · Accepted solution]

Hi Ramandeep,

I believe you could use a post-clone clean up script. I hope this helps

Use system clone

Thanks,

Berny

[ramandeepgarg6]

Hi Berny,

Thank you for looking into it! Could you please tell if I want to update 3 tables and 6 fields from each table then also can we consider it a good approach? Won't it have any impact?

Regards

Ramandeep

[bernyalvarado]

Hi Ramandeep,

It's ok to update 3 tables and 6 fields, still... I believe a better approach for you is to encrypt or mask sensitive data. The following should be helpful:

Masking Sensitive PII data (aka SSN) in ServiceNow Fields

https://www.servicenow.com/content/dam/servicenow/documents/whitepapers/wp-data-encryption-with-serv...  

Thanks,

Berny

[ramandeepgarg6]

Hi Berny,

Thanks for your reply! I was reading about Edge encryption. Edge Encrytion seems to be a major change which includes enable plugin and seems fer more major changes. Also it has limitation that business rule will not be applied on encrypted fields and also export will not work etc. So I think "Cleanup scripts" will be a good option. Please let me know if you also agree and have the same opinion because requirement is not that complex?

Regards

Ramandeep