how to get list of users and associated group in bulk in Azure

Question

how to get list of users and associated group in bulk in Azure

Vithyavathi Karunagaran 0

Hi Team,

Good day

Can you share me steps to get list of users and associated group for that ids in bulk .
i tried option to export users but that is not listed group details , can you share me the way to get it.

Akhilesh Vallamkonda 15,320 Reputation points Microsoft External Staff Moderator

2023-10-18T06:50:52.04+00:00
Hello @Vithyavathi Karunagaran

Thank you for reaching us!

I understand your concern that you are trying to get the list of users with their groups.

To achieve you're ask it is possible to use Windows PowerShell as below.

In your local machine Navigate to Windows PowerShell and Run the PowerShell in ISE as Administrator.

Connect to Entra ID using the command: Connect-AzureAD and sign in with your admin credentials.

Run the following scripts in PowerShell which retrieves a list of all users and their group memberships, and it exports the CSV file into your local machine. The path which is shown in the script is an example, you can change the path according to your requirements.

$users = Get-AzureADUser -All $true $results = @() foreach ($user in $users) { $userGroups = Get-AzureADUserMembership -ObjectId $user.ObjectId $result = [PSCustomObject]@{ UserPrincipalName = $user.UserPrincipalName DisplayName = $user.DisplayName Groups = ($userGroups | ForEach-Object { $_.DisplayName }) -join ', ' } $results += $result } $results | Export-Csv -Path C:\UserGroupMemberships.csv -NoTypeInformation

Thanks,
Akhilesh.
Vithyavathi Karunagaran 0 Reputation points

2023-10-18T14:27:39.2233333+00:00

Thanks Akhilesh for your reply .

But unfortunately this is not met the requirement , I want a user and which group that user is part of .. That output is missing . Since user may have more than one group need a list of group in same output , since this ask is common for Extract.

Eg - User id is ******@kyndryl.onmicrosoft.com

I m part of 'N' number of IAM group , i need the same output for entire listed users too in Powershell / CLI . is there a way to solve in better way .

Thank you
Akhilesh Vallamkonda 15,320 Reputation points Microsoft External Staff Moderator

2023-10-19T05:43:48.17+00:00

Hi @Vithyavathi Karunagaran

I have tested the script in our lab and the result is expected, which you can find in the below screenshot.

If the error persist, for further troubleshooting, could you please share the error details. Also, please send us an email on azcommunity [at] microsoft [dot] com referencing this issue with a subject line "ATTN: Akhilesh" along with you Azure subscription id and we will help you with alternative support options on this.

Thanks,
Akhilesh.

Your answer

Akhilesh Vallamkonda 15,320 Reputation points Microsoft External Staff Moderator

2023-10-18T06:50:52.04+00:00

Hello @Vithyavathi Karunagaran

Thank you for reaching us!

I understand your concern that you are trying to get the list of users with their groups.

To achieve you're ask it is possible to use Windows PowerShell as below.

In your local machine Navigate to Windows PowerShell and Run the PowerShell in ISE as Administrator.

Connect to Entra ID using the command: Connect-AzureAD and sign in with your admin credentials.

Run the following scripts in PowerShell which retrieves a list of all users and their group memberships, and it exports the CSV file into your local machine. The path which is shown in the script is an example, you can change the path according to your requirements.

$users = Get-AzureADUser -All $true $results = @() foreach ($user in $users) { $userGroups = Get-AzureADUserMembership -ObjectId $user.ObjectId $result = [PSCustomObject]@{ UserPrincipalName = $user.UserPrincipalName DisplayName = $user.DisplayName Groups = ($userGroups | ForEach-Object { $_.DisplayName }) -join ', ' } $results += $result } $results | Export-Csv -Path C:\UserGroupMemberships.csv -NoTypeInformation

Thanks,
Akhilesh.
Vithyavathi Karunagaran 0 Reputation points

2023-10-18T14:27:39.2233333+00:00

Thanks Akhilesh for your reply .

But unfortunately this is not met the requirement , I want a user and which group that user is part of .. That output is missing . Since user may have more than one group need a list of group in same output , since this ask is common for Extract.

Eg - User id is ******@kyndryl.onmicrosoft.com

I m part of 'N' number of IAM group , i need the same output for entire listed users too in Powershell / CLI . is there a way to solve in better way .

Thank you
Akhilesh Vallamkonda 15,320 Reputation points Microsoft External Staff Moderator

2023-10-19T05:43:48.17+00:00

Hi @Vithyavathi Karunagaran

I have tested the script in our lab and the result is expected, which you can find in the below screenshot.

If the error persist, for further troubleshooting, could you please share the error details. Also, please send us an email on azcommunity [at] microsoft [dot] com referencing this issue with a subject line "ATTN: Akhilesh" along with you Azure subscription id and we will help you with alternative support options on this.

Thanks,
Akhilesh.

Share via

how to get list of users and associated group in bulk in Azure

Your answer