Mike LaPointe

My feedback

  1. 22 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    An error occurred while saving the comment
    Mike LaPointe commented  · 

    I was able to add myself as an admin using Powershell so all hope isn't lost. I just looped the whole list since there were a number of these sites that had been created under a user who left. Just replace your tenant and email address of the admin below:

    #Variables for processing
    $AdminURL = "https://tenant-admin.sharepoint.com/"
    $AdminName="SPAdmin@tenantDomain.com"

    #Connect to SharePoint Online
    Connect-SPOService -url $AdminURL -credential (Get-Credential)

    #Get All Site Collections
    $Sites = Get-SPOSite -Limit ALL

    #Loop through each site and add site collection admin
    Foreach ($Site in $Sites)
    {
    Write-host "Adding Site Collection Admin for:"$Site.URL
    Set-SPOUser -site $Site.Url -LoginName $AdminName -IsSiteCollectionAdmin $True
    }

Feedback and Knowledge Base