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 Online site inventory
Exports a tenant-wide SharePoint Online site collection inventory with stable admin-focused properties and no fabricated activity data.
Generated locally in your browser · Runs in your PowerShell environment · Review before running
What this PowerShell script does
Exports a tenant-wide SharePoint Online site collection inventory with stable admin-focused properties and no fabricated activity data.
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.
- CSV output path - Use a new absolute Windows CSV path, for example C:\Temp\sharepoint-sites.csv.
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 Online site inventory in the Builder, review the generated PowerShell and run it in your own environment.
When to use this template
Exports SharePoint Online site collection metadata for administration, reporting and migration inventory. OneDrive personal sites are excluded by the tenant cmdlet unless a dedicated OneDrive inventory is used.
Important limitations
- Does not report last activity because no unsupported activity field is inferred.
- Does not crawl lists, libraries, files or permissions.
- OneDrive personal sites are intentionally excluded; use the dedicated OneDrive inventory in a later batch.
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 a tenant-wide SharePoint Online site collection inventory with stable admin-focused properties and no fabricated activity data. 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 metadata and does not intentionally change SharePoint settings 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.
- CSV output path - Use a new absolute Windows CSV path, for example C:\Temp\sharepoint-sites.csv.
Output
Output: CSV report with Url, Title, Template, GroupId, GroupConnected, Owner, StorageUsageMB, StorageQuotaMB, SharingCapability, HubSiteId, LockState and Status.
This template is available in the free library and is generated locally in your browser.
Example use
Exports a tenant-wide SharePoint Online site collection inventory with stable admin-focused properties and no fabricated activity data.
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. Sign in with your own Entra app/client ID (or a configured PnP default client ID) and a SharePoint Administrator account. Choose a new CSV path and review the generated script before running it.
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.