List of active sites in Tenant with Admins and storage used

Summary

This script provides you the list of active sites in your tenant with their administrator and usage in MB.

Why It Matters / Real-World Scenario

In many Microsoft 365 tenants, SharePoint sites can quickly grow in number, with varying levels of administrative access and external sharing. Without visibility, it’s easy for unused or inactive sites to remain accessible, or for administrators to have unnecessary access to sensitive content.

For example, an organization may have hundreds of departmental and project sites, some of which have never been used or have files shared externally. Security and compliance teams need to know:

Which sites have active administrators.
Which sites have sensitive data shared externally.
How recently sites have been used.
The age of sites for lifecycle and archiving decisions.

This script addresses these challenges by providing a single, comprehensive report. It allows administrators to identify inactive or outdated sites, review external sharing risks, and ensure that administrative permissions are appropriate. The insights generated help enforce least-privilege access, improve governance, and support compliance audits across the tenant.

PnP PowerShell V2
PnP PowerShell


param(
    [Parameter(Mandatory=$true)]
    [string]$AdminURL,

    [Parameter(Mandatory=$true)]
    [string]$OutputFile,

    [switch]$IncludeLastActivity,

    [switch]$IncludeExternalSharing
)

# Connect once to Admin Center
Connect-PnPOnline -Url $AdminURL -Interactive

# Get all SharePoint sites once
$sites = Get-PnPTenantSite -IncludeOneDriveSites -Detailed
$results = @()

foreach ($site in $sites) {
    try {
        Write-Host "Processing site: $($site.Url)" -ForegroundColor Green

        # Get site collection admins directly from the tenant-wide site object
        $admins = $site.Owner | ForEach-Object { $_.Title }

        # Storage usage from tenant site object
        $storageSize = $site.StorageUsageCurrent
        $createdDate = $site.CreationDate

        $lastActivity = $null
        $externalSharing = $null

        if ($IncludeLastActivity) {
            # Connect to site once to get last modified item
            Connect-PnPOnline -Url $site.Url -Interactive
            $lastItem = Get-PnPListItem -List "Documents" -PageSize 1 -SortField "Modified" -SortOrder Descending -ErrorAction SilentlyContinue
            if ($lastItem) {
                $lastActivity = $lastItem.FieldValues.Modified
            }
        }

        if ($IncludeExternalSharing) {
            Connect-PnPOnline -Url $site.Url -Interactive
            $externalFiles = Get-PnPSharingForSite -Detailed | Where-Object { $_.SharedWithUsers -match "External" }
            $externalSharing = if ($externalFiles) { "Yes" } else { "No" }
        }

        $siteInfo = [PSCustomObject]@{
            SiteUrl = $site.Url
            SiteName = $site.Title
            Administrators = $admins -join ";"
            StorageSizeMB = $storageSize
            CreatedDate = $createdDate
            LastActivity = $lastActivity
            ExternalSharing = $externalSharing
        }

        $results += $siteInfo
    }
    catch {
        Write-Host "Error processing site $($site.Url): $_" -ForegroundColor Red
    }
}

# Export once
$results | Export-Csv -Path $OutputFile -NoTypeInformation -Encoding UTF8
Disconnect-PnPOnline
Write-Host "Site inventory exported to $OutputFile" -ForegroundColor Green

Check out the PnP PowerShell to learn more at: https://aka.ms/pnp/powershell

The way you login into PnP PowerShell has changed please read PnP Management Shell EntraID app is deleted : what should I do ?


Connect-PnPOnline -Url "https://contoso-admin.sharepoint.com/" -Interactive
        
# Get all SharePoint sites
$sites = Get-PnPTenantSite

# Create an array to store the results
$results = @()

# Iterate through each site and gather required information
foreach ($site in $sites) {
    $siteUrl = $site.Url
    
    Connect-PnPOnline -Url $siteUrl -Interactive

    # Get site administrators
    $admins = Get-PnPSiteCollectionAdmin | Select-Object -ExpandProperty Title

    # Get site storage size
    $storageSize = Get-PnPTenantSite -Url $siteUrl | Select-Object -ExpandProperty StorageUsageCurrent

    # Create a custom object with the site information
    $siteInfo = [PSCustomObject]@{
        SiteUrl = $siteUrl
        Administrators = $admins -join ";"
        StorageSize = $storageSize.ToString() +" MB(s)"
    }

    # Add the site information to the results array
    $results += $siteInfo
}

# Output the results as a CSV file
$results | Export-Csv -Path "SiteInventory.csv" -NoTypeInformation

# Disconnect from SharePoint Online
Disconnect-PnPOnline

Check out the PnP PowerShell to learn more at: https://aka.ms/pnp/powershell

The way you login into PnP PowerShell has changed please read PnP Management Shell EntraID app is deleted : what should I do ?

Contributors

Author(s)
Diksha Bhura
Josiah Opiyo

Disclaimer

THESE SAMPLES ARE PROVIDED AS IS WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING ANY IMPLIED WARRANTIES OF FITNESS FOR A PARTICULAR PURPOSE, MERCHANTABILITY, OR NON-INFRINGEMENT.