July 2021 – PhoeNIXBird Networks

[SPS] SharePoint Server Subscription Edition is in preview now

July 21, 2021 Andrei Rachita 0

Microsoft just released the preview version of the next SharePoint on-premises server, called now: SharePoint Server Subscription Edition. More info: https://www.microsoft.com/en-us/download/details.aspx?id=103322 Below you can find […]

[SPO/EXO] Generate a report of Teams and their associated SharePoint Online sites

July 12, 2021 Andrei Rachita 0

So, here goes:

#Import Exchange Online Module
Import-Module ExchangeOnlineManagement   
#Connect To Exchange Online
Connect-ExchangeOnline -UserPrincipalName admin@tenant.com 
#Get the teams list
$TeamsList = [System.Collections.Generic.List[Object]]::new()
$Teams = Get-UnifiedGroup -Filter {ResourceProvisioningOptions -eq "Team"}
#Loop through Teams
ForEach ($Team in $Teams) {
  $TeamLine = [PSCustomObject][Ordered]@{
      Team = $Team.DisplayName
      SPOSite = $Team.SharePointSiteURL 
      ManagedBy = $Team.ManagedBy }
  $TeamsList.Add($TeamLine)
}
#Export Results to Gridview
$TeamsList | Out-GridView
#Remove # to export to filesystem
#$TeamsList | Export-CSV -NoTypeInformation c:\temp\TeamsSPOList.CSV

#Import Exchange Online Module

Import-Module ExchangeOnlineManagement

#Connect To Exchange Online

Connect-ExchangeOnline -UserPrincipalName admin@tenant.com

#Get the teams list

$TeamsList = [System.Collections.Generic.List[Object]]::new()

$Teams = Get-UnifiedGroup -Filter {ResourceProvisioningOptions -eq "Team"}

#Loop through Teams

ForEach ($Team in $Teams) {

$TeamLine = [PSCustomObject][Ordered]@{

Team = $Team.DisplayName

SPOSite = $Team.SharePointSiteURL

ManagedBy = $Team.ManagedBy }

$TeamsList.Add($TeamLine)

}

#Export Results to Gridview

$TeamsList | Out-GridView

#Remove # to export to filesystem

#$TeamsList | Export-CSV -NoTypeInformation c:\temp\TeamsSPOList.CSV

The results will be similar to: and the CSV Export: Enjoy!