The Problem
A company needed to find what was causing their SharePoint storage to fill up. Having a large amount of files and SharePoint sites made finding the cause almost impossible and very impractical.
Technology Used
- Microsoft Excel
- Microsoft Graph API
- PowerShell Script
The Solution
Setting up a PowerShell script provided the client with a reliable and thorough system, allowing them to monitor large files at their fingertips. This system included using Task Scheduler to automate the gathering of information on a weekly basis. The information was then collated into an easy-to-understand and use Excel spreadsheet.
Using PowerShell enabled the complex tasks that Power Automate does not offer, with the integration of Microsoft Graph API. This workflow can also be adjusted to increase the threshold of file size based on the client’s needs. Having the ability to simply open an Excel spreadsheet and access a list containing direct links to the files ensures significant time savings and frictionless monitoring of large files.
Alternatives and Additional Options
- Have additional filters for file type or location
- Take the data and use it to send notifications or track storage with other systems like SharePoint lists.
