Download all Attachments from Attachments table

Go to solution
vijay39
Giga Expert

‎02-15-2019 10:38 AM

HI Folks,

I have a requirement like, i need to download all the attachments from sys_attachment table at once or 10k per time. Using REST i think i can do this. But can some one please help me in process how to download the attachments in bulk.

 

Regards,

Vijay

  • 11,912 Views
1 ACCEPTED SOLUTION

Go to solution
asifnoor
Kilo Patron
In response to vijay39

‎02-19-2019 06:42 AM

Hi Vijay,

You can use the same process as mentioned in this link. With slight modifications, you can get to download all attachments.

https://www.servicenowguru.com/scripting/download-attachments-zip-file/#comment-34336

Please note that the script might take time and if you want to limit to N number of records, you can do so in the below script. 

Few points to Note

1. The count variable is added to the file name to avoid duplicate file names. If there are duplicate file names, the zip process will break.

2. The script is modified to simply query sys_attachment and download them in the processor. It is not capturing any parameters from UI action as such. 

3. Create the UI action as a form button on any incident or any other table.

  var zipName = 'attachments.zip';
  var StringUtil = GlideStringUtil;
  var gr = new GlideRecord('sys_attachment');
  gr.query();
  if (gr.next()){
    g_response.setHeader('Pragma', 'public');
    g_response.addHeader('Cache-Control', 'max-age=0');
    g_response.setContentType('application/octet-stream');
    g_response.addHeader('Content-Disposition', 'attachment;filename=' + zipName);
    var out = new Packages.java.util.zip.ZipOutputStream(g_response.getOutputStream());
    var count=0;
    while (gr.next()){
        var sa = new GlideSysAttachment();
        var binData = sa.getBytes(gr); 
        //add counter so that the filename is NOT duplicate
        var file = gr.file_name+"-"+count; 
	gs.info("Entered into this loop"+file);
	addBytesToZip(out, zipName, file, binData);
        count ++;
    }
    // Complete the ZIP file
    out.close();
}

function addBytesToZip (out, dir, file, stream){
    // Add ZIP entry to output stream.
    out.putNextEntry(new Packages.java.util.zip.ZipEntry(file));
    out.write(stream, 0, stream.length);
    out.closeEntry();
}

I ran this in my dev instance and it worked fine. The script takes time to download all the attachments. To test the script, i suggest you break the loop above at 5 or 10 records.

Mark the comment as correct and also helpful once worked.

View solution in original post

19 REPLIES 19

Go to solution
anezka_neckarov
Tera Contributor

‎11-29-2021 08:15 AM

Hi, 

is it possible to use this in background script? 

I need to use it only for one-time solution, but when I use g_response in background script, there is error: "g_response is not defined"

But I thought it is a global variable (docs link)

 

Could someone clarify it to me, please?

0 Helpfuls

Go to solution
Shiva Kumar8
Kilo Guru
In response to anezka_neckarov

‎11-29-2021 08:53 PM

Hi,

Please user this script in processors so that it will help you to extract all attachments

please type processor in the left navigation and modify the script according to your requirement.

Go to solution
anezka_neckarov
Tera Contributor
In response to anezka_neckarov

‎12-02-2021 01:52 AM

got it, 

g_response can be use only in processor 

0 Helpfuls

Go to solution
KLewis
Kilo Sage
In response to anezka_neckarov

‎01-26-2022 01:36 PM

Can this be done without a processor? Seems like we're no longer able to create processors in the newer version.