查找 SharePoint Online 中的所有 Office 365 组网站

要求：获取 SharePoint Online 中的所有组网站。

如何在 SharePoint Online 中查找所有组连接的团队网站？

新的 SharePoint Online 管理中心列出了所有组网站和新式网站。您可以登录SharePoint Online管理中心>>单击“活动站点”，然后查找“主管理”列，其中有“组管理”以获取所有SharePoint Online组网站集的列表。

此外，我们还有“Microsoft 365 Group”专栏来识别群组网站！

SharePoint Online：使用 PowerShell 列出组网站

我们可以根据模板筛选网站集，以获取启用 Microsoft 365 组的网站。在 SharePoint Online Management Shell 中运行这些 PowerShell 脚本行。

#Set Admin Center URL
$AdminCenterURL = "https://crescent-admin.sharepoint.com/"

#Connect to SharePoint Online
Connect-SPOService -url $AdminCenterURL -Credential (Get-Credential)

#Get All Group Sites
Get-SPOSite | Where { $_.Template -like 'GROUP*'} | Select URL

这将为您提供所有群组网站的列表！

获取 SharePoint Online 中的所有组网站并导出为 CSV：

让我们获取群组网站列表，并将数据从 SharePoint 端导出到 CSV 文件。

#Set Admin Center URL
$AdminCenterURL = "https://crescent-admin.sharepoint.com/"
$ReportOutput="C:\Temp\GroupSites.csv"

#Connect to SharePoint Online Admin Center
Connect-SPOService -Url $AdminCenterURL -Credential (Get-Credential)

#Get All Group Sites
$GroupSites = Get-SPOSite -Limit All -Template 'GROUP#0' -IncludePersonalSite:$False
Write-host "Total Number of Group Sites Found:"$GroupSites.count

$SiteData = @()
#Loop throgh each site
ForEach($Site in $GroupSites)
{
    #Get Group Site Data
    $SiteData += New-Object PSObject -Property @{
                'Site Title' = $Site.Title
                'URL' = $Site.Url
                'Last Modified' = $Site.LastContentModifiedDate
                'StorageUsed' = $Site.StorageUsageCurrent              
                }
}
#Export the data to CSV
$SiteData | Export-Csv $ReportOutput -NoTypeInformation
Write-Host -f Green "Group Sites Data Exported to CSV!"

以及脚本输出报告：

如何获取SharePoint网站的Office 365组？

我们还可以从 Exchange Online 获取 Microsoft 365 组的所有 SharePoint 网站：

$SiteURL = "https://Crescent.sharepoint.com/sites/Legal"

#Connect to Exchange Online
Connect-ExchangeOnline -ShowBanner:$False

#Find the Office 365 group using the SharePoint site URL
$Group = Get-UnifiedGroup -ResultSize Unlimited | Where { $_.SharePointSiteUrl -eq $SiteURL}
Write-host $Group.Guid

#Disconnect Exchange Online
Disconnect-ExchangeOnline -Confirm:$False

使用 Exchange Online PowerShell 获取组网站

让我们使用 Exchange Online PowerShell 获取所有 Office 365 组和关联网站。

#Get Credentials to connect
$Credential = Get-Credential
 
#Connect to Exchange Online
Connect-ExchangeOnline -Credential $Credential -ShowBanner:$False

#Get All Office 365 Groups
$Groups = Get-UnifiedGroup -ResultSize Unlimited -SortBy Name
        $GroupSites = @()
        $Groups | Foreach-Object {
            $Group = $_
            $SiteURL = $Group.SharePointSiteUrl
            If($SiteURL -ne $null){
                $GroupSites += New-Object -TypeName PSObject -Property @{
                      GroupName = $Group.Alias
                      GroupUrl = $SiteURL
                      EmailAddress = $Group.EmailAddress
                      DisplayName = $Group.DisplayName
                      Privacy = $Group.AccessType
                      Owners = $Group.ManagedBy
                      Created = $Group.WhenCreated
                      Changed = $Group.WhenChanged
                }
            }
        }
        $GroupSites

#Disconnect Exchange Online
Disconnect-ExchangeOnline -Confirm:$False