A decade or so ago, I had written code to analyze user files on shared storage.

I used a perl script to collect file extensions, and metadata, and stored that in an access database.

SQL queries could be run to give summaries like - what percent of disk was eaten by mp3 and video files, Photos, etc. Also - which user was hogging disk , with a summary of top 20 users, and what volumes of "non-corporate" stuff they had.

An interesting side-effect was the discovery of a treasure-trove of ... well .. lets call it unsavory material.

I imagine there are probably many such, far more professionally written packages available for things like this, but I'm willing to try to dig up the old code, on request.