Clone User table from Prod to Sub prod instance

[Ash41]

Hi Team, 

We are planning to Clone the Prod to Sub-prod including "Sys_user" table, my questions are

1. If we clone, will it create new accounts or update existing users accounts?

2. We have some web service accounts too, will it update the passwords too? will it impact on credentials.

3. Does this impact any user login credentials? 

4. Also, does it copy roles and groups same as prod?

Please suggest, thank you.

[Mark Roethof · Accepted solution]

Hi there,

It depends if you have clone preservers/excludes on your instance. Though if not:

1. Existing user accounts will be overwritten

2. Yes passwords will be overwritten

3. Again yes

4. Yes sys_user_grmember, sys_user_has_role, etc. will be copied

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark
2020-2022 ServiceNow Community MVP
2020-2022 ServiceNow Developer MVP

---

LinkedIn
Community article, blog, video list

[Ash41]

Hi Mark, 

Thank you

Will it Wipe out existing user accounts in sub-pord? if sys_id's doesn't match?

[Mark Roethof]

If you don't have any preservers in place, yes all will be wiped and replaced with what is in the source instance.

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark
2020-2022 ServiceNow Community MVP
2020-2022 ServiceNow Developer MVP

---

LinkedIn
Community article, blog, video list

[Mark Roethof]

Hi there,

Any follow-up needed? Or was my answer sufficient?
Let me know.

If your question is solved, please close the topic by marking my answer as correct. This will help others searching for a similar question and will remove the topic from the unsolved list.

Kind regards,
Mark
2020-2022 ServiceNow Community MVP
2020-2022 ServiceNow Developer MVP

---

LinkedIn
Community article, blog, video list