Ideas

Every media file has per design a corresponding entry in the table Media.File. However - sometimes a media file is removed in the database but not deleted on disk resulting in a number of unlinked and unknown "orphaned" media files.

This can also occur due to mistake when copying/moving between environments or artifacts.

The lack of ways to find those superfluous media makes them a permanent clutter and waste of diskspace. Especially on serverless where we have no file system access.

Solution is to add a feature to scan for the orphaned media files in the file system. Present them as potential waste in backoffice and delete after 30 days.

As an antithesis this tool should also detect broken links in the DB. I.e. links pointing to missing files.