Possible to retrieve blobs from the sys_attachment table via ODBC?

AnchorTrust
Kilo Contributor

‎06-11-2014 07:00 AM

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

0 Helpfuls
  • 1,463 Views
2 REPLIES 2

lawrence_eng
Administrator
Administrator

‎06-16-2014 04:50 PM

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


0 Helpfuls

Jacob_Andersen
ServiceNow Employee
ServiceNow Employee

‎06-16-2014 07:05 PM

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.


0 Helpfuls