Export servicenow data with attachments.

[Vedasri1]

Hi,

I am trying to exporting a table with attachment, I created "database view" with sys_attachment, sys_attachment_doc and incident table. But after exporting the table I am getting name of a attached file instead of the attached file. Can anyone explain how to export the a data (records) from servicenow with attachment.

Thanks & Regards,

Vedasri.

[Vedasri1]

Hi,

Thank you Rammohanrao. I have one more doubt, after exporting to XML format we get base64 encoded chunck data pf attached file right. From this encoded data can we get original attached file?

Regards,

veda.

[rammohanraomadd]

Hi Vedasri,

Yes we can decode the base64 data and get as an attachment.

Regards,

Ram M.

[Vedasri1]

I know that we can convert base64 encoded data. But hear we get base64 encoded 4k chunck data right. How w can convert it into original attached file. I tried but I have not get in to original file.

https://community.servicenow.com/community?id=community_article&sys_id=870d2ea5dbd0dbc01dcaf3231f96192f

I am following this link, hear I am not understand  How they decoded. These are line for decoding what I not understood. 

(base64_decode each chunk, It will build a gzip archive, gunzip this archive ).

can you please explain with example by decoding.

Thanks & Regards,

Veda.

[Vedasri1]

Hi Exports,

Can anyone please help to download all attachments at a time. I do not have much time. my production instance going to expire in 2 days. I have above 2k attachments. Can any one please help me to download all attachments at once.

Thanks & Regards,

Vedasri.