List all failed site design for all sites

Summary

The following script iterates through all site collections and lists all site design runs with errors. By filtering on OutcomeCode == '1' it will return all sites and runs with explicit errors. By filtering on OutcomeCode != '0' you can also return any result that is not marked as successful.

• CLI for Microsoft 365 with PowerShell

Copied

$allSPOSites = m365 spo site classic list -o json | ConvertFrom-Json
$siteCount = $allSPOSites.Count
Write-Output "Processing $siteCount sites..."
foreach ($site in $allSPOSites) {
    $siteCounter++
    Write-Output "Processing $($site.Url)... ($siteCounter/$siteCount)"
    $runs = m365 spo sitedesign run list --webUrl $site.Url --output json | ConvertFrom-Json
    foreach ($run in $runs) {
        $runData = m365 spo sitedesign run status get --webUrl $site.Url --runId $run.ID --query '[?OutcomeCode == `1`]' --output json | ConvertFrom-Json
        if ($runData) {
            Write-Output "$($run.SiteDesignTitle) failed at $($site.Url) with id $($run.ID)"
        }
    }
}

Check out the CLI for Microsoft 365 to learn more at: https://aka.ms/cli-m365

Source Credit

Sample first appeared on List all failed site design for all sites | CLI for Microsoft 365

Contributors

Author(s)
Albert-Jan Schot

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.