Powershell - get name and mobile from group with more than 5000 members

Lars

3/3/24, 9:46 AM

I need to extract the name and mobile of all users in an AD group that consists of more than 5000 members.

When I previously did this I only had to extract the name, and this code solved my problem

Get-ADGroup 'xxx' -Properties Member | Select-Object -ExpandProperty Member | Sort
Get-ADGroup "xxx" -Properties Member | Select-Object -ExpandProperty Member | Get-ADObject | Select Name | Sort Name
((Get-ADGroup "xxx" -Properties member).member).count
Get-ADGroup "xxx" -Properties Member | Select-Object -ExpandProperty Member | Get-ADObject | Select Name | Sort Name  | Export-Csv C:\temp\exportmembers.csv -Encoding UTF8 -NoTypeInformation

Since groups don't contain the property "mobile" I'm unsure how to go about this.

Any help is appreciated.

383

1 + 0

powershell

active-directory

Score:1

Server

Gerald Schneider

3/3/24, 9:58 AM

You can get all group members directly using Get-ADGroupMember, even with subgroups

get-adgroup 'xxxx' |Get-ADGroupMember -Recursive |
  get-aduser -Properties name,mobile |sort name |select name,mobile |
  Export-Csv C:\temp\exportmembers.csv -Encoding UTF8 -NoTypeInformation

For the +5000 member issue, just add the property to Get-AdObject and Select-Object

Get-ADGroup "xxx" -Properties Member | Select-Object -ExpandProperty Member | 
  Get-ADObject -Properties mobile | Select Name,mobile | Sort Name  | 
  Export-Csv C:\temp\exportmembers.csv -Encoding UTF8 -NoTypeInformation

+ 3

Lars

3/3/24, 10:46 AM

Thanks for the reply, but because there's more than 5000 members in the group I get an error saying "Get-ADGroupMember : The size limit for this request was exceeded". When I googled I found that the cap is 5000 members for ADGroupMember, which is why I included that in the OP. Any chance you know how to get around this?

Gerald Schneider

3/3/24, 10:53 AM

@Lars see my edit

Lars

3/3/24, 10:55 AM

Thank you so much!

Elon Musk

I sit in a Tesla and translated this thread with Ai:

EN: Powershell - get name and mobile from group with more than 5000 members

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.