Download the free version of the SharePoint Essentials Toolkit Community Edition to allow running this report (https://cognillo.com).
Although a SharePoint administrator can get storage metrics and information about list and large file sizes in SharePoint Site Settings, there are often requirements to get more in depth reports on files and folders.
SharePoint content is not as straight forward as your native Windows file system, as there is metadata and versioning (version history) space used by every document. In order to get a true picture of the storage space used by each file and folder, it requires the SharePoint API or other Microsoft web services (such as GRAPH), using programming (such as C#) or PowerShell to obtain this information.
How to get storage space used out-of-the-box
Storage capacity used in your SharePoint sites can be found by navigating to Site Settings => Storage Metrics:
While this is useful, it does not show which files or folders are using the space listed. In addition, it only reports for the current Site Collection, and not across multiple sites.
SharePoint Inventory Report using the SharePoint Essentials Toolkit
You can download the SharePoint Essentials Toolkit Community Edition for free to get many useful reports at no cost.
Below is the Item Inventory report which will show a list of all SharePoint lists, libraries, folders and file content, with storage space used, including file path lengths, total versions, author, etc…
Simply select the SharePoint sites and lists to include, and click ‘Run’.
Currently working at Cognillo (https://www.cognillo.com), he has helped architect and develop SharePoint Enterprise products for customers such as the U.S. Navy, U.S. Army, U.N. Security Council of Netherlands, Australian Government, U.S. Dept of Treasury, U.S. Dept of Justice, Canadian Dept of Defense, Scotiabank, JPMorgan CHASE Bank, Intel, Ford Motors, Microsoft, NASA, DARPA, SNC Lavalin, Penguin Books, and more.
He is a proud father of 2, and when he has any spare time, he loves to paint portraits of his kids.
- How to get SharePoint list and folder sizes - February 16, 2025
- Copy a List in SharePoint or Microsoft 365 and keep version History - December 10, 2024
- FREE SharePoint Permission Reports - December 4, 2024