如何将 Office 365 团队获取团队和获取团队用户结果导出到 CSV 文件

Question

我想像这种格式导出到 csv 文件。

Team name | User name | Role
================================

但是，获取团队用户 cmdlet 结果是

Userid | User | Name | Role
===============================

我该怎么办？

Answer 1

您可以使用如下所示的计算表达式

get-teamuser |select @{
Name = 'Team name';  Expression = {$_.name}},@{ Name = 'user name';  Expression = {$_.user +' '+$_.name}},role| export-csv -path c:teamsdata.csv

Answer 2

脚本如下所示：

Connect-MicrosoftTeams
$output=@()
$teams = Import-Csv "C:Get-Team Wise user detailsTeams.csv" 
ForEach ($team in $teams) {
$teamUsers = Get-TeamUser -GroupId $team.GroupId 
ForEach ($teamUser in $teamUsers) {
$userObj = New-Object PSObject 
$userObj | Add-Member NoteProperty -Name "Team Display Name" -Value $team.DisplayName
$userObj | Add-Member NoteProperty -Name "User Name" -Value $teamUser.Name
$userObj | Add-Member NoteProperty -Name "User SMTP Address" -Value $teamUser.User
$userObj | Add-Member NoteProperty -Name "User Role" -Value $teamUser.Role
$output += $userObj
Write-Output "$($team.DisplayName);$($teamUser.Name);$($teamUser.User);$($teamUser.Role)"
}
}
$output | Export-csv -Path C:BatchWiseUserDetails.csv -NoTypeInformation -Encoding UTF8

导入 CSV 只需要有一个名为"组 ID"的列