Get-AdUser where mail is not null

Question 1

I am trying to get a list of all users in AD that have an email (mail attribute). I have this command

Get-AdUser -filter * -Properties mail | Select SAMAccountName, mail | Export-CSV -Path $userPath -NoTypeInformation

1 2	Get-AdUser -filter * -Properties mail \| Select SAMAccountName, mail \| Export-CSV -Path $userPath -NoTypeInformation

The problem is that I do not know how to limit or filter out users where the email is null/blank. I do not care how complex the script is as it will be part of a much larger powershell script. If the solution is to loop through the CSV that is an option but would prefer something quicker. Does anyone know how to do this?

Question 2

Try this:

Get-ADUser -Properties mail -Filter {mail -like '*'}

1 2	Get-ADUser -Properties mail -Filter {mail -like '*'}

Get-AdUser where mail is not null

Question:

Answer:

Source:

Get-AdUser where mail is not null by stackoverflow.com licensed under CC BY-SA | With most appropriate answer!

Leave a Reply Cancel reply