Forum Discussion
Comparing # of SPO sites to Teams sites
My company is new to O365, and my boss asked me to give him the number of SPO sites we had, vs the number of Teams sites. So I ran the following two commands: PS C:\Users\>> $sites = Get-SPOSite ...
You can just filter the list based on the Template property, it should have value: GROUP#0
But for your scenario, as you might not know the team to which a given site corresponds, you're better off looking at the properties of the underlying Office 365 group:
Get-UnifiedGroup groupname | Select SharePointSiteUrl
The problem then becomes listing all groups that correspond to a Team, and for that you can use the Teams PowerShell module, or some of the workarounds we discussed previously here: https://techcommunity.microsoft.com/t5/Microsoft-Teams/view-a-list-of-all-Teams-that-have-been-created-in-Microsoft/td-p/65067