How can I get a list of all site collections in my SharePoint Online farm including ones for Office 365 Groups?

I've ran into problems when creating a new site collection where I'm unaware that an Office 365 group already exists with the same url. The cause is not always obvious because sometimes I get an error where it says that the site already exists and other times I get an access denied error even though I am a Global Admin.

1 Answer 1


PowerShell based solution:

Download SharePoint Online Management Shell


Run the commands below to get a list of all site collections

Connect-SPOService -Url "https://tenantname-admin.sharepoint.com" 

  • This is correct, but just to note, this is a new capability of the tool. If you have an older version of the shell, it will only output "regular" site collections. if this happens, install an updated version of the shell.
    – Mike2500
    Mar 17, 2017 at 17:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.