Find a Specific File Type and the Amount of Space It Is Using
This uses the NS7 Inventory Solutions tables.
We recently needed to scan our environment for media files that weren't necessarily allowed, at the same time we decided to determine how much data they were using. So I wrote this SQL query to populate this information, I will build it into a flexible report soon to follow this article. This will take the table which is read in KB and move it to MB for easier relation, it also filters based on primary user / month. This way we can make sure that the data is as close to up to date as possible..