Need Guidance to Export and Download All Attachments
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-08-2020 03:03 PM
We have an audit requirement we need to complete to bulk export and download attachments that are attached to incidents and requests. We need to complete this audit in the next two weeks. What is the best way to do this? We do have an ODBC connection already setup for our ServiceNow data, can we leverage that connection to assist with this export and download? I did some research and see that the attachments are stored in the sys_attachment table. Actual data of the attachment is chunked and stored in sys_attachment_doc table.
I have seen older posts with https://www.servicenowguru.com/scripting/download-attachments-zip-file/#comment-34336 mentioned but recently saw a post that this is not working on the New York version.
Does anyone know if this will still work on the New York build?
If not, any ideas?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-08-2020 03:31 PM
Solution mentioned in https://www.servicenowguru.com/scripting/download-attachments-zip-file works in newyork on my instance.
But, in our company instance, we are using data pump utility to export data with attachments from service now tables to remote oracle DB instance.
Check below for more details
https://sourceforge.net/projects/servicenowpump/
This is working well in our company instance.
Regards,
Sachin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-11-2020 05:59 AM
You could use SnowMirror to replicate or backup all your ServiceNow attachments.
www.snow-mirror.com