What it works with
Module: PnP.PowerShell
Context: PowerShell 7.4+ · SharePoint Online · PnP.PowerShell
Compatibility: PowerShell 7.4+ is required by current PnP.PowerShell releases.
POWERSHELL / SHAREPOINT
FreeBeginnerRead-onlylow
Export SharePoint storage usage and quotas
Exports SharePoint site storage usage, quota and utilization percentage for migration sizing and capacity work.
Generated locally in your browser · Runs in your PowerShell environment · Review before running
What this PowerShell script does
Exports SharePoint site storage usage, quota and utilization percentage for migration sizing and capacity work.
Requirements
- SharePoint admin URL - Example: https://contoso-admin.sharepoint.com
- Entra app client ID - Your PnP app client ID. Leave empty only when a PnP default client ID is already configured.
- Warning threshold (%) - Marks sites at or above this storage-utilization percentage.
- CSV output path - Use a new absolute Windows CSV path.
Environment
- Module: PnP.PowerShell
- Runtime: PowerShell 7.4+
- Authentication: Interactive PnP login with your own Entra app/client ID or configured default
- Permissions: SharePoint AllSites.Read delegated access + SharePoint Administrator role / tenant-admin-site access.
- Risk: Low
Review before you run The generated script is read-only, but authentication and access requirements still apply in your tenant.
OPS / WORKSPACE
Ready to generate
Configure Export SharePoint storage usage and quotas in the Builder, review the generated PowerShell and run it in your own environment.
When to use this template
Produces a focused capacity report from detailed site metadata. Utilization is only calculated when a positive quota is available.
Important limitations
- StorageUsedPercent is blank when a positive quota is not available.
- No file-level or library-level storage breakdown is performed.
- OneDrive personal sites are excluded from this SharePoint site report.
PowerShell and PnP requirements
Current PnP.PowerShell releases require PowerShell 7.4 or later. Interactive authentication requires your own Entra application/client ID, or a default client ID that you have configured for PnP.PowerShell. Opselith does not connect to SharePoint or run the script on your behalf.
Generate the script
- Open the template in the PowerShell Builder.
- Enter the requested URLs, client ID (when needed) and a new CSV output path.
- Generate the script, review its permissions and commands, then run it in your own PowerShell environment.
OPS / SCRIPT DETAILS
Script details
Exports SharePoint site storage usage, quota and utilization percentage for migration sizing and capacity work. Review these details before generating or running the script.
Permissions and impact
Permissions: AllSites.Read · SharePoint Administrator
Risk: Low
Execution impact: Read-only. The script reads SharePoint tenant site storage metadata and does not change storage quotas or content.
Parameters
- SharePoint admin URL - Example: https://contoso-admin.sharepoint.com
- Entra app client ID - Your PnP app client ID. Leave empty only when a PnP default client ID is already configured.
- Warning threshold (%) - Marks sites at or above this storage-utilization percentage.
- CSV output path - Use a new absolute Windows CSV path.
Output
Output: CSV report with Url, Title, StorageUsageMB, StorageQuotaMB, StorageUsedPercent, AboveWarningThreshold, Template and GroupConnected.
This template is available in the free library and is generated locally in your browser.
Example use
Exports SharePoint site storage usage, quota and utilization percentage for migration sizing and capacity work.
Enter the required values in the Builder, review the generated script and confirm the output before running it.
Before you run: Use PowerShell 7.4+ with PnP.PowerShell and SharePoint Administrator access. Storage is read from tenant site metadata; no libraries or files are enumerated. Choose a new CSV output path.
Opselith quality checks
- Included in the current Opselith PowerShell quality suite
- Current PnP.PowerShell runtime and interactive-auth requirements documented
- Read-only behavior and minimum permissions documented
- Stable CSV column order and explicit zero-result behavior
- Review-before-run guidance provided
- No artificial pacing inside SharePoint enumeration loops
Was this useful?One click. No email.