I have a couple of orgs where they are running over their file storage limits. There are a lot of old files that need to be removed, but I'm struggling to get a view/report/query together that will clearly indicated against which records these files are being stored.
The problem is exacerbated by the fact that they are littered through the system. There are uploads via their community, by email-to-case, by marketing emails, etc.
In one case, there are around 120GB of file in storage, but when I run a report on Content, Files, and Attachments, I can only see around 2.5GB worth of files being reported.
Is there anyone who has managed to audit file usage/location etc, so that the excesses files can be deleted/removed/archived?