Summary

Summarize file and folder counts per user, along with quota allocated and quota consumed, for the folders under a given path.

Details

A customer needed a management-facing report showing file and folder counts, each user’s quota, and how much of that quota was being used, with empty directories excluded.

This custom query summarizes the folders in the path provided on line 7. The report shows file and folder counts, size used, the quota value set, and the quota remaining.

Note: This query is written for Active Directory and can be modified for use with eDirectory.

Code

Because this query is long, please download the ZIP file, which contains both the SQL query and the report layout.