question

HridayDhali-1476 avatar image
0 Votes"
HridayDhali-1476 asked sandeg-MSFT commented

Multiple group Member details download from Azure

From the Azure portal I would like to perform the below job, how can I do that

  1. Want to download all members of Group A, Group B, and Group C with group mapping

  2. All member details with associated group, from example user1 has member of 5 group , it should show all groups name corresponding to user name


azure-active-directoryazure-database-postgresqlazure-database-mysql
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

sandeg-MSFT avatar image
0 Votes"
sandeg-MSFT answered sandeg-MSFT commented

@HridayDhali-1476

Thank you for reaching out to us.

As per your query you want to download members of few groups in Azure and also you want to get the group membership details of all users.

You can get this information in 2 different ways,
• Azure portal
• Azure AD PowerShell

Via Azure portal you can only see the user who all are part of particular group,

205241-1.jpg

You can use PowerShell method to get all the list of users who are part of particular group,

• Open Windows PowerShell as administrator.
• Install Azure AD Module by running below command,
• Install-Module AzureAD
• Once module is installed you can type in command ”Connect-AzureAD”
• Enter the global admin credentials.
• Run command ”Get-AzureADGroupMember -ObjectId <Object ID of a group>”. You will see below output with list of all members of this group.

205176-2.jpg


You can use this PowerShell method to get list of all members of particular group.

You also wanted to get user’s group membership information. Below is the command to get the information about user group membership (group to which user is part off)
Run command “Get-AzureADUserMembership -ObjectId <user object ID>”.
Below is the screenshot of how the output will look,


205231-3.jpg

Above is the list of groups to which user is part of,

Do let me now if you have any further questions on this.

Thanks,
Sandeep G

Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.



1.jpg (26.5 KiB)
2.jpg (24.3 KiB)
3.jpg (23.2 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks for your answer, you may be misunderstood my requirement

I am looking for multiple groups, not a particular group.
The mentioned method is for a single group

Again I am articulating my query, multiple group members with mapping for example
1000 User is members of 10 different groups

I want all details with the user and group mapping
User a ---group B
User a ---group D
User b --- group A
User c -- group B

0 Votes 0 ·
sandeg-MSFT avatar image sandeg-MSFT HridayDhali-1476 ·

@HridayDhali-1476

Thank you for your response. This is not possible through Azure portal UI.
However, I will look into this query and check if we can achieve this using PowerShell.

1 Vote 1 ·