Adding to this table one record at a time can be a slow process, but if you have a list of all the sys_id's then this process can be remarkably sped up by utilizing ServiceNow's Import a translation from an Excel spreadsheet function.
Prerequisites
First, you will need to create a bulk share without executing it
Then, enable share only sys_ids listed
Procedure
To quickly add records to the u_psp_bulk_share_sys_id table, follow these steps:
First, you will need to create an Excel spreadsheet with the following format:
Save the Excel spreadsheet.
NOTE: Notice that the Bulk Share column uses the display name of the bulk share instead of the sys_id. The record will not be created correctly if you use the sys_id of the bulk share.
Navigate to the u_psp_bulk_share_sys_id table in ServiceNow by typing "u_psp_bulk_share_sys_id.list" in the navigation bar and hit enter.
Right click the top of the table and click "Import"
You will be brought to the following screen where you will click "Choose File" and select the Excel sheet you made in step 1. Once you've selected the file, click Upload.
Click "Preview Imported Data"
Finally, click Complete Import and your u_psp_bulk_share_sys_id table will be populated with the records listed in the Excel spreadsheet
For more information, contact Perspectium Support.
