Connect-AzureAD
#$group = Get-AzureADGroup -Id "<GUID>"
#this all works for standard AD group
#$group = Get-ADGroup -Filter "Name -eq 'Adobe - Staff Licensed Users (Home)'"
$groupMembers = Get-AzureADGroupMember -ObjectId "cdda615a-b5a7-4e46-9d5c-bc86a5270158" -All $true
$allUsers = Get-ADUser -Filter * -Properties GivenName,Office,Title,Department,SamAccountName,Enabled
$results = @()
foreach ($user in $allUsers) {
$obj = New-Object PSObject -Property @{
AccountName = $user.SamAccountName
Name = $user.DistinguishedName
MemberOf = if ($groupMembers.userPrincipalName -contains $user.SamAccountName + '@<DOMAIN>.ac.uk' ) { "Is a Member" } else { "Not a Member" }
JobTitle = $user.Title
Department = $user.Department
Office = $user.Office
Enabled = $user.Enabled
}
Write-Output $obj
$results += $obj
}
$results | Export-Csv -Path "c:\temp\GroupMembers-EXPORT-6.csv" -NoTypeInformation