Move user and roles from one instance to another

paradise624
Tera Contributor

Hi All,

I've created a new user and role in DEV along with a few ACLs in 2 update sets. I then batched those 2 update sets and exported them out as XML and imported them into Test,

Now that I'm in test I see the user and role made it over in the update set to test, however I don't see the user or role in test. What happened? Why don't I see the user or role eventhough it made it over to test in the xml import?

7 REPLIES 7

Akanksha Gupta2
Mega Guru

Hi , 

Pls refer below link :-

https://www.basicoservicenowlearning.in/2020/08/import-user-role-group-servicenow.html#:~:text=So%20...

pls mark it correct or helpful.

Reagrds,

Akanksha

Tony Chatfield1
Kilo Patron

Hi, if you are not xmling the table records directly but using an update set as indicated then you will need to preview and apply the update set. If using XML direct an upload would fail if the source and target instances have different fields on the table - you can fix this by adding\removing fields from the xml with a text editor.

 

Saurabh Gaikwad
Mega Expert
Hello paradise624,
 
Basically update set can not capture the Users and role.
If we want move the users and role from one instance to another then we have to use import xml.
for that first.
sys_user , sys_user_role, sys_user_has_role, from this three table apply the filter and get your record whatever you want, then click on column level menu and select the Export as XMl.
after that open target instance go to that perticular table for ex. if you want import the user then go to sys_user table and click on column level menu and select import user and uplod the xml files , do the same things for role (sys_user_role) and sys_user_has_role (This table contain the user with roles).
 
And you can refer this link teh you can better understand.
 
 
 

I hope this will help you.

Mark ✅ Correct/ Helpful if this helpful for you.
 
Regards,
Saurabh.
 
 
 

ex.

I have attach the screenshot for understanding purpose.

find_real_file.png