Setup: O365 Tenant with Teams
Problem: List all SharePoint sites associated with Teams
Solution: Run the following PowerShell
Connect-ExchangeOnline # Yes, we need to query Unified Group and we need to connect to Exchange
Get-UnifiedGroup -Filter {ResourceProvisioningOptions -eq "Team"} | Select DisplayName,SharePointSiteUrl