You may find yourself in a situation where you are required to update a large quantity of records extracted from a ServiceNow instance, outside of ServiceNow. An important step to completing bulk updates is ensuring you’re updating the correct records. Luckily, ServiceNow already has this problem partially solved for us by making the SysId unique identifier available. The question is: How do you get an export of data that includes the SysID column? You can’t normally add the column to a list view or a report and exporting the data as Excel from the list view does not include it.
The solution is ServiceNow’s Easy Import Process. This will allow you to generate a template that includes the columns you want Plus the SysID column.
Note: This functionality is limited to the Admin role.
It’s as easy as that!
Now you have a template you can share with the requestor. They can then update the fields accordingly, and you can craft a transform map to utilize it (or reimport the data with the import tool by attaching the file under “Step 2,” as pictured above).