Is there a way to backup the sys_user table before a mass update

nico2 · ‎03-06-2020

Hello,

Is there a way to backup the sys_user table before a mass update?

We can clone the instance but if we need to restore the instance we lose incident data that was created.

Any ideas are welcome.

Prateek kumar · ‎03-06-2020

Is your question answered??
If yes, please mark my response as correct and helpful and close this thread.
This helps in removing this thread from unanswered list and helps community.

Please mark my response as correct and helpful if it helped solved your question.
-Thanks

View solution in original post

Prateek kumar · ‎03-06-2020

You can export data as XML
https://docs.servicenow.com/bundle/orlando-platform-administration/page/administer/development-best-...

Please mark my response as correct and helpful if it helped solved your question.
-Thanks

Alexey7 · ‎03-06-2020

Navigate to the table you want to backup, right click on any column "hambuger" menu and select Export XML, then hit download and it'll download all records to your computer.

Hope it helps.

nico2 · ‎03-06-2020

Thank you for the update Alexey are there any corresponding tables that I should also backup ?

Prateek kumar · ‎03-06-2020

You would have to take the XML's of the reference fields too.

Like the location, department etc., the user is assigned to

Please mark my response as correct and helpful if it helped solved your question.
-Thanks