User records Import

[Gousia Syed1]

Hi,

I have imported a User from DEV to UAT, but the roles missed to that user. Do i need to give roles seperately in UAT.

Also by mistake i imported the User record using Retrived updateset in other case. Does this impact any thing?But the user record get created in sys_user table only even i did using retrived updateset in higher instance. 

Thanks,

Ruby

[Ahmmed Ali]

Hello @Gousia Syed1 

User record table is data table and not Configuration table, and will not be captured in update set. To keep the sys_id of user record same in all instances, you can open that user record ( list view if more than one), right click on header and select export > XML. The downloaded XML can be loaded to higher instances as below:

Open user table > Right click on header > import XML > select your file and update.

The roles will be in different table, you can add roles manually in higher instances. Though, best practice would be to add user to group and assign roles to group.

Refer: https://docs.servicenow.com/en-US/bundle/utah-platform-administration/page/administer/roles/task/t_A.... 

Regarding your question about importing in retrieved update set table, when you import XML in ServiceNow, it does not matter which table you selected XML import, target table details will be present in XML file and data gets copied to correct target table.

Hope your query is answered.

Thank you,

Ali

[Munender Singh]

Hello Ruby,

Yes, please add the roles manually. 

It doesn't matter where have you posted your xml file, the record will get inserted or updated in the relevant table only.

Regards,

Munender