Generate a report for OneDrive users exceeding 500GB

Question

Please help me with a powershell script that i can use to get a report on OneDrive users exceeding 500GB of space used.

Answer 1

Hi @MKHULEKO THABISO NHLAMBO,

The Get-OneDriveSizeReport.ps1 PowerShell script exports all Microsoft 365 users OneDrive sizes to a CSV file. Find the file OneDriveSizeReport.csv in the path C:\temp.

Open the CSV file with your favorite application. In our example, it’s Microsoft Excel.

You can filter in the CSV file by UsedGB field greater than 500.

To run the script, you need to Install Microsoft Graph PowerShell first. Please take a reference to this step-to-step article: Export OneDrive usage report with PowerShell script.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.