Active Directory Powershell: Export all users with a specific email domain

Question

Active Directory Powershell: Export all users with a specific email domain

Bühler Gabriel 81

Hello Everyone

I am trying to export a List of all Users who have the same E-Mail-domain (for Example *@email.com) so I set up this script:


$results = Get-ADUser -Filter * -SearchBase "OU=OUNAME,OU=OUABOVE,OU=OUAbove, OU=MAINOU,DC=DOMAINNAME,DC=net"  -Properties "SAMAccountname", "GivenName", "Surname", "Title", "Division", "Department", "EmailAddress" , "Manager", "TelephoneNumber" | Select "SAMAccountname", "GivenName", "Surname", "Title", "Division", "Department", "EmailAddress" , "Manager", "TelephoneNumber"
$filter= $results | where {$_.email -contains "*@email.com"}
$export = $results | Export-CSV "C:\Users\GBU101\external_user_superiormail.csv" -Append -NoTypeInformation

I also tried with "Emailaddress" and "Email" but it was not able to find anything.

Do you may know what the issue could be?

Thank you for your help.

Kind regards,

Gabe

Accepted answer

1 additional answer

Your answer

Answer 1

It might be the extraneous space in the Organizational Unit name:

"OU=OUNAME,OU=OUABOVE,OU=OUAbove, OU=MAINOU,DC=DOMAINNAME,DC=net"
                                 ^
                                 |
                                 +---- This

But it's also (more) likely that it's use of "-contains" instead of "-like" in the Where-Object cmdlet, and your use of the property "mail" instead of the "EmailAddress" in the same conditional statement.

You can also make your code more readable:

$props = "SAMAccountname", "GivenName", "Surname", "Title", "Division", "Department", "EmailAddress" , "Manager", "TelephoneNumber" 
Get-ADUser -Filter * -SearchBase "OU=OUNAME,OU=OUABOVE,OU=OUAbove,OU=MAINOU,DC=DOMAINNAME,DC=net"  -Properties $props |
    Select-Object $props | 
        Where-Object {$_.EmailAddress -LIKE "*@email.com"} |
            Export-CSV "C:\Users\GBU101\external_user_superiormail.csv" -Append -NoTypeInformation

Bühler Gabriel 81 Reputation points

2023-08-08T15:15:51.5733333+00:00

Thanks! No, the space only occured because I edited it so that you don't see the actual path im using. It now works with "like".

Answer 2

Ian Xue-MSFT 41,691 Microsoft External Staff

Hi

The "-contains" operator tells whether a set includes a certain element. In your case, the only element of the emailaddress property is the mail address itself. You can use a matching operator such as "-like" or "-match" to match a string to a specified pattern.

$results | where {$_.EmailAddress -match '@lab.local'}

$results | where {$_.EmailAddress -like '*@lab.local'}

https://learn.microsoft.com/en-us/powershell/module/microsoft.powershell.core/about/about_comparison_operators

Best Regards,

Ian Xue

If the Answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Rich Matheisen 47,856 Reputation points

2023-08-09T15:04:08.0266667+00:00

The problem with using regular expressions is that inexperienced folk forget that there are 'special' characters that have an effect on the matching. The use, for example, of the period in your example. Did you mean "any single character", or "match a period"?

Also, the un-anchored string will match a substring. I'm assuming you meant the match domain portion of the email address that ends with the (literal) string "@lab.local". That regex should end with a "$" (end of string) -- but may have to end with either "\z" or "\Z" instead depending on whether the string ends with a line break or you're ignoring line breaks as string terminators.

Sorry to go all pedantic, but regular expressions are a language, and there are also dialects within the language which varies with the regular expression engine used.

Share via

Active Directory Powershell: Export all users with a specific email domain

1 additional answer

Your answer