Get various properties of a SharePoint site collection using different PnP Syntaxes.

 My task was to create a report detailing various properties of a SharePoint site collection. Identifying which properties corresponded to specific PowerShell syntax required additional time. 

Ultimately, I developed this script to determine which properties are available in different syntaxes such as PnPTenantSite, PnPSite, and PnPWeb in PnP.Powershell module.

This script has proven to be very useful in understanding the properties. Please adjust the input as per your requirements; I have included all site collections in the tenant. The output is exported into CSV files.

Replace your Azure App ClientID and AdminSiteUrl. When using -Interactive in Connect-PnPOnline, you will see the credentials pop-up a couple of times. I used to keep the SP admin center site logged in on the default browser with same credentials to reduce the number of interactive sessions.

# Define the parameters for the Azure AD app

$clientId = "123456-a789-b123-456c-d78901234"

$AdminSiteUrl = "https://yourtenant-admin.sharepoint.com"

# Connect to SharePoint Online using the Azure AD app credentials

Connect-PnPOnline $AdminSiteUrl -Interactive -ClientId $clientId

# Get all site collections

$siteCollections = Get-PnPTenantSite -Detailed

# Initialize arrays to store properties

$tenantSitePropertiesList = @()

$sitePropertiesList = @()

$webPropertiesList = @()

# Loop through each site collection and get detailed properties

foreach ($site in $siteCollections) {

    $siteUrl = $site.Url

   

    # Connect to each site collection

    Connect-PnPOnline -Url $siteUrl -Interactive -ClientId $clientId

   

    # Get PnPTenantSite properties

    $tenantSiteProperties = Get-PnPTenantSite -Identity $siteUrl

    $tenantSitePropertiesList += $tenantSiteProperties

   

    # Get PnPSite properties

    $siteProperties = Get-PnPSite

    $sitePropertiesList += $siteProperties

   

    # Get PnPWeb properties

    $webProperties = Get-PnPWeb

    $webPropertiesList += $webProperties

}

# Export properties to CSV files

$tenantSitePropertiesList | Export-Csv -Path "D:\PnPTenantSiteProperties.csv" -NoTypeInformation

$sitePropertiesList | Export-Csv -Path "D:\PnPSiteProperties.csv" -NoTypeInformation

$webPropertiesList | Export-Csv -Path "D:\PnPWebProperties.csv" -NoTypeInformation

# Disconnect from SharePoint Online

#Disconnect-PnPOnline

Write-Host "The detailed properties have been exported to PnPTenantSiteProperties.csv,

PnPSiteProperties.csv, and PnPWebProperties.csv."

You can also run this script on a single site collection to obtain the properties. I ran it on all site collections to cross-verify the properties.