The ‘Check attachments’ job runs automatically daily. 

It checks the integrity of the attachments data, as well as giving a summary of the storage used.

It will report if an attachment is listed but not physically present.