Skip to content

Instantly share code, notes, and snippets.

@win2000b
Created July 30, 2020 16:02
Show Gist options
  • Save win2000b/2bf14dc731bdf6db6dc2295eede9a67d to your computer and use it in GitHub Desktop.
Save win2000b/2bf14dc731bdf6db6dc2295eede9a67d to your computer and use it in GitHub Desktop.
Query All Microsoft Teams and Export list of guests
# Connecting to Teams
Connect-MicrosoftTeams
# Connecting to Azure AD
Connect-AzureAD
#Get list of all Teams
$AllTeams = get-team
# For each team extract members
foreach ($team in $AllTeams)
{
$groupmembers = Get-AzureADGroupMember -ObjectId $team.groupid
foreach ($member in $groupmembers)
{
$array=[ordered]@{
"Group ID"=$team.groupid;
"Group Name"=$team.DisplayName;
"Guest Name"=$member.DisplayName;
"Email Address"=$member.mail;
"Type"=$member.UserType;
}
If ( $member.UserType -eq 'Guest') {
$obj=New-Object -TypeName psobject -Property $array
Export-Csv -path "c:\temp\TeamsGuests.csv" -InputObject $obj -Append -NoTypeInformation
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment