We're in a situation where the physical file attachments, the attmnt table and the usp_lrel_attachments* tables are out of sync.
Situation:
- Physical files are stored on disk, but have no corresponding record in attmnt
- The usp_lrel_attachments* have records, but point to purged cr and chg records.
Example query:
select count(id) from
usp_lrel_attachments_requests with (nolock)
where cr not in (select persid from call_req with (nolock))
Question: Are there any OOTB solutions to reconcile this, similar to the CORA cleanup utility?
Thank you.