Due to the excessive size of the fileattachments folder we had to move our SDP installation from C Drive to a new D Drive.
After this move we have found that all (if there are exceptions to this they haven't been found) old attachments cannot be opened and some new calls are experiencing the same issue.
This move was done by another technician in around August.
When I browse D:\ManageEngine\ServiceDesk\FileAttachments\Request, I can see Aug2013, Oct2013 and Sep2013 folders.
When I attempt to open an attacment to a request created yesterday via a preventative maintenance task fails with the message
The File was not found. When I run the following query against the servicedesk database I can see the request in the results and the AttachmentPath value is ..\fileAttachments\Request\Oct2013\66385\Changing the Key.nrl.
When I browse to the path there is no 66385 folder.
SELECT
*
FROM
[servicedesk]
.
[dbo]
.
[SDeskAttachment]
WHERE
[ATTACHMENTNAME]
LIKE
'Changing%'
Is there someway of finding where attachments are being stored/expected by SDP and any advice on how to resolve this issue?
Thanks,
Matt