ADSI to CSV

ADSIToCSV.ps1

Import-Module ActiveDirectory

$MeGroups = Get-ADGroup -Filter {Mail -like "*"} -Properties Mail,Members,msExchHideFromAddressLists | Where-Object {$_.msExchHideFromAddressLists -ne $true}
 
Write-Host "There are" $MeGroups.Count "mail enabled groups (Security & Distribution)"
 
ForEach ($Group in $MeGroups) {
 
    $GroupDN = $Group.DistinguishedName
 
    ForEach ($Member in $Group.Members) {

        $memberADInfo = Get-ADUser -Filter {DistinguishedName -like $Member} -Properties GivenName,SurName,msExchHideFromAddressLists 

        [PSCustomObject]@{
            GroupName  = $Group.Name
            GroupDN    = $GroupDN
            MemberDisplayName = $memberADInfo.Name
            MemberFirstName = $memberADInfo.GivenName
            MemberLastName = $memberADInfo.SurName
            MemberSamAccountName = $memberADInfo.SamAccountName
            MemberDistinguishedName = $memberADInfo.DistinguishedName
            MemberHiddenFromGal = if ($memberADInfo.msExchHideFromAddressLists -eq $true) {$true} else {$false}
        } | Export-Csv C:\Users\richard-admin\Documents\Scripts\MailEnabled-Users.csv -NoTypeInformation -Append -NoTypeInformation -Append
    }
}