How to Find Attachments in Attachments Folder

Symptoms

Attachments are stored on filesystem but there isn't any attachment in the attachments folder.

Cause

The attachment naming scheme is numerical so as to avoid encoding problems with operating systems.

Resolution

You can look for the attachment detail (e.g file type, attachment name) from ATTACHMENTS table. As attachment is stored as this structure : <attachments>/pageID/attachment/attachmentVersion, you may want to run the following query to retrieve attachments of a page:

Select * from ATTACHMENTS where pageID='<PageID>'

You can determine the missing attachments by using the Missing Attachments Report.

Additional Information