This script connects to the Microsoft Graph API and retrieves all members of a specified Azure AD group, filtering for a group named "365-2fa." It exports selected properties like userPrincipalName and displayName for each group member into a CSV file at a defined output path. The script ensures the output directory exists before exporting and provides error handling for permissions or directory issues, making it useful for auditing group memberships in Azure AD.
Here is the script:
# Prompt the user to enter Tenant Id or Primary domain$TenantId = Read-Host "Please enter Tenant Id or Primary domain"
# Define the scopes needed for the Microsoft Graph API permissions$Scopes = "User.Read.All,AuditLog.Read.All,Directory.Read.All"
# Connect to Microsoft GraphConnect-MgGraph -Scopes $Scopes
# Define group id$Group = Get-MgGroup -All | where {$_.DisplayName -like “365-2fa”}$GroupId = $Group.Id
# Define the output path$OutputPath = "C:\temp\MembersExport.csv"
# Check if the directory existsif (!(Test-Path -Path (Split-Path -Path $OutputPath -Parent))) { Write-Host "The directory does not exist. Please check the output path and try again." return}
# Export Members with specified propertiestry { Get-MgGroupTransitiveMember -All -GroupId $GroupId | Select-Object Id, @{Name="userPrincipalName"; Expression={$_.AdditionalProperties.userPrincipalName}}, @{Name="displayName"; Expression={$_.AdditionalProperties.displayName}} | Export-Csv -Path $OutputPath -NoTypeInformation Write-Host "Export successful. The file is located at $OutputPath"} catch { Write-Host "Failed to export users. Please check your permissions and try again."}
Help Center