How to restore a deleted role and its references without scripts

Description

When a role is accidentally deleted, a cascade deletion can occur which will remove all references to that role. Users without the role will no longer be able to access various applications, modules, data, etc. This article will instruct an administrator on how to manually restore the record and references without the use of scripts.

Solution

Requirements:

• The user performing the data restoration should have the 'admin' role.
• Another instance (SOT / source-of-truth) which contains the role and references must be available in order to extract this data. 
• The 'name' of the role and it's 'sys_id'

If the 'admin' role was deleted and you are unable to import the xml files to restore the data, please contact ServiceNow support. 

Test Case:

The 'itil' role was accidentally deleted:

Instructions: 

1. Undelete / restore the 'itil' role:
   1. Option #1 - 
      Open the module 'Deleted Records', open the 'itil' role record and undelete it.
   2. Option #2 - 
      On the SOT instance, export to .xml a copy of the 'itil' role then import into the instance with the missing role.
      /nav_to.do?uri=sys_user_role.do?sys_id=282bf1fac6112285017366cb5f867469
      
      
2. Restore these references by exporting to .xml from the SOT instance then import into the instance where the deletion occurred. This will restore the core references which are needed for the role to function properly. 
   /sys_user_role_contains_list.do?sysparm_query=role%3D282bf1fac6112285017366cb5f867469%5E
   /sys_app_application_list.do?sysparm_query=roles%3Ditil
   /sys_app_module_list.do?sysparm_query=roles%3Ditil
   /sys_security_acl_role_list.do?sysparm_query=sys_user_role%3D282bf1fac6112285017366cb5f867469%5E
   /sys_user_role_contains_list.do?sysparm_query=contains%3D282bf1fac6112285017366cb5f867469%5E
   /pa_dashboards_permissions_list.do?sysparm_query=role%3D282bf1fac6112285017366cb5f867469%5E
   /sys_embedded_help_role_list.do?sysparm_query=role%3D282bf1fac6112285017366cb5f867469%5E
   /sys_group_has_role_list.do?sysparm_query=role%3D282bf1fac6112285017366cb5f867469%5E
   /sys_ui_action_role_list.do?sysparm_query=sys_user_role%3D282bf1fac6112285017366cb5f867469%5E
   /sys_user_has_role_list.do?sysparm_query=role%3D282bf1fac6112285017366cb5f867469%5E
   
   
3. Check for any remaining references which may need to be restored. If any are found, create a new URL similar to the ones above then repeat restoration steps.
   1. This will give you all the tables which contains a field that references the Roles (sys_user_role table):
      • /sys_dictionary_list.do?sysparm_query=internal_type%3Dreference%5Ereference%3Dsys_user_role
   2. This will give you all the tables which contains a list collector field that references the Roles (sys_user_role) table: 
      • /sys_dictionary_list.do?sysparm_query=internal_type%3Duser_roles

Applicable Versions

All

Additional Information