Get mail from AD and replace with name

Question

Get mail from AD and replace with name

RASH MAAR 421

Hi team,
My goal is to create a CSV file with two data, the name of all the servers from Active Directory and the email of its owner.
In the first step I am asked about all the servers and who owns them:

$Servers = Get-ADComputer -Filter * -SearchBase 'OU=Servers,OU=CONTOSO Computers,DC=contoso,DC=lan' -Properties ManagedBy | Select-Object -Property Name, @{label='ManagedBy';expression={$_.ManagedBy -replace '^CN=|,.*$'}}

And now I have the names of the servers and the names of their owners in such mode:
Name ManagedBy
Server1 Stevo Polyi
Server2 Rich Turner
Server3 Kirk Baltz

Now I need to ask AD about the email of each of the names in ManagedBy and replace the name with the email, and here's the part I need help with. I tried all sorts of ways to query AD with the names in $Server.ManagedBy without success.
I would appreciate your help Thanks

2 answers

Your answer

Answer 1

Rich Matheisen 47,901

See if this works for you:

Get-ADComputer -Filter -SearchBase 'OU=Servers,OU=CONTOSO Computers,DC=contoso,DC=lan' -Properties Name, ManagedBy | 
    ForEach-Object{
        [PSCustomObject]@{
            Name = $_.Name
            ManagedBy = (Get-ADUser $_.ManagedBy | Select -Expand mail)
        }
    } Export-CSV c:\junk\X.csv -NoTypeInformation

You may need to use Get-ADObject instead of Get-ADUser if the ManagedBy property contains the DN of an object other than a user.

RASH MAAR 421 Reputation points

2021-01-19T21:30:48.603+00:00
Gets the following error, The same goes for Get-ADObject:

Get-ADUser : A parameter cannot be found that matches parameter name 'Expand'.
At line:5 char:50

ManagedBy = Get-ADUser $_.ManagedBy -Expand EMailaddress

~~~~~~~

CategoryInfo : InvalidArgument: (:) [Get-ADUser], ParameterBindingException

FullyQualifiedErrorId : NamedParameterNotFound,Microsoft.ActiveDirectory.Management.Commands.GetADUser
Rich Matheisen 47,901 Reputation points

2021-01-19T22:01:57.293+00:00
Place the in parentheses . . . also, The "-Expand" was supposed to belong to a "Select" cmdlet, which I completely missed typing (although it was there in my head!) E.G.:

ManagedBy = (Get-ADUser $_.ManagedBy | Select -Expand EMailaddress)

I'll correct the code example I posted.

RASH MAAR 421

Thanks.
The result is the names of the servers and an empty field of the owner.
I can do this for one server this way:

            $11Server = Get-ADComputer -Filter {Name -eq 'EXchangeServer'} -Properties ManagedBy | Select-Object -Property Name, @{label='ManagedBy';expression={$_.ManagedBy -replace '^CN=|,.*$'}}  
            $22Owner = $11Server.ManagedBy  
            $33mail =  Get-ADUser -Filter {Name -eq $22Owner} -Properties mail | Select-Object mail  
            $11Server.ManagedBy = $33mail.mail  
            $11Server  
          
        Name                      ManagedBy  
        EXchangeServer      ******@Contoso.com

How do I make this happen for a list of servers as in the first example?
Thanks

Rich Matheisen 47,901 Reputation points

2021-01-20T02:51:49.493+00:00

Sorry. I don't have a Active Directory to work with any longer, so I'm working from memory. It looks to me as if I simply have the wrong property name in the Select. You should be able to use "Mail" instead of "EMailaddress" I used. Just be aware that the "Mail" attribute may be populated on a user that's not a Mailbox user.

I'll change the code sample I posted to use the "mail" attribute. That'll work in almost every case, but getting an Exchange mailbox or mail-enabled object's working email address is better served by using the PrimarySMTPAddress property. That' at least, is managed by your Exchange organization's email address policies.

Answer 2

Andreas Baumgarten 123.4K MVP Volunteer Moderator

The ManagedBy attribute returns a CN?

If so, maybe this will help (not tested):

Get-ADUser -LDAPFilter '(cn=<CN of Managed By User>' -Properties EmailAddress | Select EmailAddress

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Andreas Baumgarten

Rich Matheisen 47,901 Reputation points

2021-01-19T21:00:54.957+00:00

IIRC, the ManagedeBy property contains the distinguishedName of an object.
Andreas Baumgarten 123.4K Reputation points MVP Volunteer Moderator

2021-01-19T21:02:35.1+00:00

Even better :-)

Kind regards
Andreas Baumgarten

RASH MAAR 421

Does not work.
Email does not exist in ManagedBy details.
In this way it does work for me, But only if I ask about one server:

        $11Server = Get-ADComputer -Filter {Name -eq 'EXchangeServer'} -Properties ManagedBy | Select-Object -Property Name, @{label='ManagedBy';expression={$_.ManagedBy -replace '^CN=|,.*$'}}
        $22Owner = $11Server.ManagedBy
        $33mail =  Get-ADUser -Filter {Name -eq $22Owner} -Properties mail | Select-Object mail
        $11Server.ManagedBy = $33mail.mail
        $11Server

    Name                      ManagedBy
    EXchangeServer      ******@Contoso.com

How do I make this happen for a list of servers as in the first example?
Thanks

Share via

Get mail from AD and replace with name

2 answers

Your answer