Import-module activedirectory
$Users = Get-ADUser -Filter * -Properties sAMAccountName
$Group = "Export*"
ForEach ($user in $Users)
{
$Check = Get-ADPrincipalGroupMembership -Identity $User.sAMAccountName | ? { $_.Name -like $Group }
If ($Check -eq $null)
{
Write-Output "$User.sAMAccountName is NOT part of this group"
}
else {
$Results = Get-ADUser -Identity $User.sAMAccountName -Properties Name, sAMAccountName, Mail |
select Name, sAMAccountName, Mail |
Export-csv "c:\results1.csv" -NTI -Append
}
}
This brought back quite a few users that DID belong to the groups
Import-module activedirectory
$Users = Get-Mailbox -ResultSize "unlimited"
$Group = "Metalogix*"
ForEach ($user in $Users)
{
$Check = Get-ADPrincipalGroupMembership -Identity $User.sAMAccountName | ? { $_.Name -like $Group }
If ($Check -eq $null)
{
Write-Output "$User.sAMAccountName is NOT part of this group"
}
else {
$Results = Get-Mailbox -Identity $User.sAMAccountName |
select Name, sAMAccountName, PrimarySmtpAddress, Database |
Export-csv "c:\results1.csv" -NTI -Append
}
}
Will.