Preserve user passwords to be overwritten when cloned

[CV1]

Hello All,

We have few local users for web access only with diff pwds for prod and DEV for testing via postman etc.

How to avoid these pwds to be overwritten and retain dev credentials after clone

• Currently once it clones, the pwds are over written with prod and having to manually change to dev .
• Also, how can admin pwds of DEV and UAT be retained with out being over written. (is it done in cleanup scripts/Exclude Tables/Preserve Data? Please explain how to do this.)

TIA

[Rupanjani]

Hi @CV1,

You can take the XML of all users before any activity being performed on the instance.
Once the activity is done, you can import the XML. Hope this works. 

[Amit Verma]

Hi @CV1 

Below links could be helpful :

https://www.servicenow.com/community/developer-forum/cloning-exclude-table-vs-preserve-data/m-p/1431...

https://www.servicenow.com/community/itsm-forum/authentication-issue-after-cloning/m-p/720486/page/2

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0715621#mcetoc_1h7f77i69a4

You need to use data preservers to achieve this. And remember you need to define them always on the source instance. 

Thanks and Regards

Amit Verma

[Mark Roethof]

Hi there,

Simply Preserving the specific User records should do the trick. Nothing more to it. Just a few seconds work to setup.

[CV1]

Hi Everyone,

Thank you for the solutions . I did not work on this before and when I ma reading up confused on these two concepts.Please advise if what i understood is correct.

So,in order to retain the pwds for the local users for web access I need to do the following

1. On the DEV instance, go to Preserve Data>New>
   Name: api user
   Application:Global
   Table:sys_user
   Conditions:UserID -contains-api_user1
   (if the above is correct, do i need to do the same on UAT as well?)
   
   
2. In order to retain Admin pwd on DEV and UAT from getting over written by clone do i need to do the same steps as in point 1 ?
3. EXCLUDE TABLES: This is used to exclude any table data to be carried down after clone. Which instance  do we need to create this record (New - )

TIA for the advise