SDP+ location of Request Resolution attachments
We migrated from on-premise SDP+ to SDP Cloud. It has been identified that some of the Requests had attachments to the Resolution section that did not get copied over. We no longer have the on-premise version installed so I can't easily go back to confirm. However, I do have the SDP+ SQL Server database and the accompanying SDP_fileAttachments folder that held the on-premise attachments.
If I query the WorkOrder table, it shows dozens of Requests that have field "HasResolutionAttachment" = 1. How can I create a query to determine the location of those attachments in the SDP_fileAttachments folder?
New to ADSelfService Plus?