How can I extract attachments out of CM tickets?

I have been trying multiple ways to extract attachments our of Service Manager using Web Services (which I read many forum post many have been unsuccessful) and directly through the SQL table SYSATTACHMEM1. Pulling directly from the table seem unreadable and web services seem difficult.

Does anyone know how (if) this can be done? Ultimately, we want to send the attachment out of SM via email to a vendor for processing after the change ticket has been approved.

Tags: