Including attachments when exporting incidents, problems, and other records

When exporting incidents, problems or other types of records with attachments, how do we export these attachments to CSV, Excel or PDF?

Note: This KB is for exporting to formats other than XML (CSV, Excel, PDF). The XML allows exports with attachments and is the recommended format to export.

It's currently not possible to bulk extract attachments along with each ticket in one go. However, you can extract attachments one by one by specifying the table name and date range. It can be done from the sys_attachment table, for example:

https://<instance-name>.service-now.com/sys_attachment_list.do?sysparm_query=table_name%3Dincident%5Esys_created_onBETWEENjavascript:gs.dateGenerate('2014-07-01'%2C'00:00:00')%40javascript:gs.dateGenerate('2014-07-20'%2C'23:59:59')

This URL shows all the attachments created in the date range from incidents. Rename the attachment based on the incident number (checking table sys_id column for the incident number).