Get-UnifiedGroup和Get-Teams:如何在powershell中创建脚本并将其导出为csv文件

# 导入必要的模块
Import-Module Microsoft.Online.SharePoint.PowerShell -DisableNameChecking
Import-Module ExchangeOnlineManagement

# 连接到Exchange Online
Connect-ExchangeOnline -UserPrincipalName your-email@example.com

# 获取统一组信息
$unifiedGroups = Get-UnifiedGroup -ResultSize Unlimited | Select-Object DisplayName, Alias, PrimarySmtpAddress, GroupType

# 获取Teams信息
$teams = Get-Teams -ResultSize Unlimited | Select-Object DisplayName, Alias, GroupId

# 将信息合并到一个数组中
$combinedData = @()
foreach ($group in $unifiedGroups) {
    $teamInfo = $teams | Where-Object { $_.GroupId -eq $group.Alias }
    if ($teamInfo) {
        $combinedData += [PSCustomObject]@{
            DisplayName = $group.DisplayName
            Alias       = $group.Alias
            Email       = $group.PrimarySmtpAddress
            TeamName    = $teamInfo.DisplayName
            GroupType   = $group.GroupType
        }
    }
}

# 导出到CSV文件
$combinedData | Export-Csv -Path "C:\path\to\output.csv" -NoTypeInformation

# 断开连接
Disconnect-ExchangeOnline