Fix “Connect-SPOService : Current site is not a tenant administration site.” Error in SharePoint Online Management Shell

Problem: When trying to connect to SharePoint Online using SharePoint Online Management Shell, got an error message: “Connect-SPOService : Current site is not a tenant administration site.” Root Cause and Solution: The script was trying to connect to SharePoint Online as: “Connect-SPOService -Url https://crescent.sharepoint.com”, But the problem is: It should connect to…

Read more

How to Create App Catalog Site in SharePoint Online?

What is App Catalog in SharePoint Online? App Catalog in SharePoint is a central location where we can manage custom-developed apps or 3rd party apps and make them available for users to download across all site collections. These apps are listed under the “From Your Organization” link when you try to add…

Read more

Find All OneDrive for Business Site Collections in SharePoint Online using PowerShell

Requirement: Get a list of all OneDrive site collections from SharePoint Online. I was asked to get the list of all OneDrive sites to get the usage of OneDrive for Business in our Office 365 tenant. It’s a bit tricky to find all of your OneDrive site collections and here is how…

Read more

SharePoint Online: Clone User Group Memberships using PowerShell

Requirement: Clone a user’s group permissions to another user in a SharePoint Online Site. PowerShell to Clone User’s Group Memberships in SharePoint Online: It’s a common real-world scenario that when someone leaves the organization and somebody else takes that role they want the same permissions! While the requirement sounds simple, it’s really…

Read more

SharePoint Online: PowerShell to Get All Groups

Requirement: SharePoint Online PowerShell to List All Groups in a Site Collection Get SharePoint Online Groups using PowerShell: Get-SPOSiteGroup The Get-SPOSiteGroup PowerShell cmdlet displays a list of all existing SharePoint groups for a specific site collection. Use SharePoint Online Management Shell console to get user groups in SharePoint Online. Get-SPOSiteGroup -Site <Site-Collection-URL>…

Read more

SharePoint Online: How to Change Site Owner using PowerShell?

Requirement: Change Site Owner in SharePoint Online using PowerShell How to Change Site Owner in SharePoint Online? Site Owners of a SharePoint Online site collections can be changed only through SharePoint Online Admin Center or PowerShell. To change site owner in SharePoint Online follow these steps: Important: You must be either Global…

Read more

Get-Set OneDrive Site Collection Storage Quota Size using PowerShell

Get OneDrive Site Collection Storage Quota Information To get the storage quota data for a particular OneDrive site, use this PowerShell cmdlet in SharePoint Online Management Shell This gets you the currently allocated storage quota data for a single site collection. Get Storage Quota Details of All OneDrive Site collections Use this…

Read more

Get All SharePoint Online Site Collections Inventory using PowerShell

Requirement: Get all site collections inventory in SharePoint Online using PowerShell PowerShell to Get All SharePoint Online Site Collections Inventory Let’s get a list of SharePoint Online sites using PowerShell: and the result: Here is the List of all properties you can retrieve from a SharePoint Online site collection: LastContentModifiedDate Status ResourceUsageCurrent…

Read more

SharePoint Online: How to Hide Default Themes?

Themes are quick ways to add branding to SharePoint Online sites. However, we wanted to restrict site owners from changing the themes for a uniform look and feel overall sites. Fortunately, SharePoint Online provides a cmdlet to hide default themes and enforce governance. PowerShell to Hide Default Themes in SharePoint Online: Open…

Read more