Can we export all attachments of the incident table?

[SNOW User8]

Hi Team,
Is there any way to export all attachments of the incident table?

Please help.

Thanks in advance.

[AbhishekGardade]

Hello SNOW,

You can export all incident attachments. In order to do that you need to download 2 XML's as attachment data is available in two different tables.

Attachment Tables: "sys_attacment" has got ONE-TO-MANY relationship with "sys_attachment_docs" table

1. sys_attachment
2. sys_attachment_docs

Refer this: Attachments in ServiceNow

Steps to download: sys_attachment:

1. In the navigation filter, enter sys_attachment.list
2. Use a filter to find the attachments you need. For example: Table Name is Incident. This will give you a list of attachments for incidents table.
3. To download Right Click between column and do as per shown below

       

Steps to download: sys_attachment_docs

• In the navigation filter, enter sys_attachment_docs.list
• Search by(show related field) then Sys Attachment-> Table name IS Incident.
• This will give you a list of attachments for incidents table.
• To download Right Click between column and do as per shown below

    

Please mark as Correct Answer and Helpful, if applicable.
Thanks!
Abhishek Gardade
Hexaware Technologies

[phoang]

Hi,

Do you know how to compile the records together after it's been exported?  I believe that it's base64 encoded and gzip.  We tried to decode and concatenate but it's not working using java.

Thanks.