asked on 10/9/2018

Extartcting users SMTP addresses

I need to query ad and extract users by display name and sammaccount and show howmany smtp addresses they have under their account

Powershell Active Directory

Last Comment

Michael B. Smith

10/9/2018

Zaheer Iqbal

10/9/2018

You can do this via the Exchange Management Shell if you have access

Get-Mailbox -ResultSize Unlimited | Select-Object DisplayName, SamAccountName, PrimarySmtpAddress, @{Name="EmailAddresses";Expression={$_.EmailAddresses | Where-Object {$_.PrefixString -ceq "smtp"} | ForEach-Object {$_.SmtpAddress}}} | Export-CSV c:\EmailAddresses.csv -NoTypeInformation -Encoding Unicode

gd6627

10/9/2018

ASKER

no I don't have exchange console I have an extended schema and I can see the proxy address for primary and alias smtp

FOX

10/9/2018

Create a folder named Temp on your c:drive
Run the following command

Get-Aduser -filter * -properties Displayname,Samaccountname,proxyaddresses | Select DisplayName,SamAccountname,Proxyaddresses | Export-csv 'c:\temp\UserResults.csv' -notypeinformation

gd6627

10/9/2018

ASKER

Hey Fox , Thanks for your repluy but the output CSV does not list the Proxy addressess

see below

Displayname       SamAccountname      Proxyaddresses
      guest-disabled      Microsoft.ActiveDirectory.Management.ADPropertyValueCollection
      localadmin      Microsoft.ActiveDirectory.Management.ADPropertyValueCollection
      krbtgt      Microsoft.ActiveDirectory.Management.ADPropertyValueCollection

FOX

10/9/2018

Where are you running the command from? This command should be run against AD, this command was not run in Exchange Management Shell. Did you open powershell as an administrator?

gd6627

10/9/2018

ASKER

Running it from my ISE ps Console i loaded the Actiuve Directory Module . I dont have exchange on Prem am looking at the ADUC properties for the Proxy address and some users have 2 proxy addresses .

When i run the script without exporting the results i see the proxy address its only when i enable the Export that it comes out like that

ASKER CERTIFIED SOLUTION

Michael B. Smith

10/9/2018

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial