Possible to retrieve blobs from the sys_attachment table via ODBC?

[AnchorTrust]

Good day all,

Just popping the question out there for anyone who might have tried this in the past.   I can certainly access the table but basically I'm trying to find a method of copying across attachment blobs from Service-Now into our own database and thought this method would be ideal (if it's possible?).

If this approach isn't a viable one.   Would you suggest a mid-server to facilitate this requirement or have another idea?

Thanks very much for taking the time.

Kind regards,

James Matthews

Anchor Trust

[lawrence_eng]

Hi James,

For better visibility, I moved your question out of the Support sub-community and into the Implement sub-community.

thanks,

Lawrence

--

Online Community Program Manager, ServiceNow

[Jacob_Andersen]

i don't know that exporting attachments via the ODBC driver is the best way to accomplish this.   I have created a UI action that you can add to any form that will allow you to download all of the attachments to a record as a ZIP file.   You could modify this script a little to even download all incident (or any other table) attachments as a ZIP file if you wished.

» Download Attachments as a ZIP File

You could also create a mid server script include to have a mid server grab attachments from your instance on a regular basis and save them to a particular location.   We did this once basing our code off of the Crossfuze Scheduled Data Extract

» Crossfuze Scheduled Data Extract

Please mark this as the answer to your question if I've given the correct answer.