Forum Discussion

fstorer's avatar
fstorer
Brass Contributor
Jan 17, 2025
Solved

Get a list of specific agegroup users stored on a security group

Dear Community, I wonder if it would be possible to get a list of users (stored in a security group) marked as "minor" and "not adult" using microsoft graph. Once I get the members of the group (usi...
azure
azure active directory
graph
office 365
Windows PowerShell
  • Andres-Bohren's avatar
    Andres-Bohren
    Jan 22, 2025

    fstorer 

    Here you go

    #Connect to Microsoft Graph
    Connect-MgGraph -Scopes 'Group.Read.All'
     
    #Create empty Array
    $MinorGroupMembers = @()
     
    #Get Entra Group
    $EntraGroup = Get-MgGroup -Filter "DisplayName eq 'AAD-AgeGroupMembers'"
     
    #Get Entra Group Members
    $GroupMembers = Get-MgGroupMember -GroupId $EntraGroup.ID
     
    #Loop through Members
    Foreach ($Member in $GroupMembers)
    {
    #Get Entra User
    $EntraUser = Get-MgUser -UserId $Member.ID -Property DisplayName, Id, Mail, UserPrincipalName, AgeGroup
    $UPN = $EntraUser.UserPrincipalName
    $AgeGroup = $EntraUser.AgeGroup
    Write-Host "$UPN > $AgeGroup"
     
    If ($AgeGroup -eq "Minor")
    {
    #Add to Array
    $MinorGroupMembers += $UPN
    }
    }
     
    $MinorGroupMembers
Andres-Bohren's avatar
Andres-Bohren
Steel Contributor
Jan 22, 2025

fstorer 

Here you go

#Connect to Microsoft Graph
Connect-MgGraph -Scopes 'Group.Read.All'
 
#Create empty Array
$MinorGroupMembers = @()
 
#Get Entra Group
$EntraGroup = Get-MgGroup -Filter "DisplayName eq 'AAD-AgeGroupMembers'"
 
#Get Entra Group Members
$GroupMembers = Get-MgGroupMember -GroupId $EntraGroup.ID
 
#Loop through Members
Foreach ($Member in $GroupMembers)
{
#Get Entra User
$EntraUser = Get-MgUser -UserId $Member.ID -Property DisplayName, Id, Mail, UserPrincipalName, AgeGroup
$UPN = $EntraUser.UserPrincipalName
$AgeGroup = $EntraUser.AgeGroup
Write-Host "$UPN > $AgeGroup"
 
If ($AgeGroup -eq "Minor")
{
#Add to Array
$MinorGroupMembers += $UPN
}
}
 
$MinorGroupMembers

Resources