For the longest time it was not possible to see Office 365 Group and Office 365 Video site collections in PowerShell using the SharePoint Online Management Shell and the Get-SPOSite cmdlet. If you declared the site directly you could see the site. Also if you used the Set-SPOSite cmdlet to set values of the site it would work but you couldn’t see all sites with one cmdlet. As of a recent release this is now possible.
- Here are instructions on how to get started using connecting to SharePoint Online via PowerShell.
- Get-SPOSite cmdlet on technet
You can also now use a -Template command to limit the query based on the site collection template which will allow you to get only Office 365 Video or Group site collections
Get all Office 365 Group site collections
Get-SPOSite -Template GROUP#0
Get all Office 365 Video site collections
Get-SPOSite -Template POINTPUBLISHINGTOPIC#0