Attachments / Schema question

Attachments / Schema question

As part of a GDPR request from a customer, I have to identify all inline images and (graphical) attachments belonging to their requests in SC+.

I've done the first part easily enough (searching the ConversationDescription table for the img tag), but I can't quite work out the schema for file attachments. Where are the paths to the file attachments stored/calculated, so that I can capture this, and process the files in the file system? I've got the workorder, conversation and attachment IDs out, and can restrict this to the correct customer, but I can't see how to actually find out where the file is stored in the file system.

USE supportcenter;
SELECT wo.WORKORDERID,
       c.CONVERSATIONID,
  ca.ATTACHMENTID,
       wo.REQUESTERID,
       au.FIRST_NAME
FROM Conversation c
     JOIN WorkOrder wo ON wo.WORKORDERID = c.WORKORDERID
     JOIN AaaUser au ON au.USER_ID = wo.REQUESTERID
     LEFT JOIN WorkOrder_Account woacc ON wo.WORKORDERID = woacc.WORKORDERID
     LEFT JOIN Customer cust ON woacc.ACCOUNTID = cust.CUSTOMER_ID
     LEFT JOIN AaaOrganization org ON cust.CUSTOMER_ID = org.ORG_ID
join ConversationAttachment ca on ca.CONVERSATIONID = c.CONVERSATIONID
WHERE org.NAME = N'MyCustomer' COLLATE Latin1_General_CI_AS

Thanks,

Chris
              New to ADManager Plus?

                New to ADSelfService Plus?