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