alias

Question

Hi experts, i am not able to put in correct words

i have a csv file with email addresses
with the help of email addresses i.e with csv file, is it possible to get generate report of alias
and SMTP email address (these email addresses have additional SMTP email address)
Please help me with the syntax

(in other words our company email policy is firstname.lastname@mydomain.com, the csv file i have is firstname.lastname@mydomain.com

when i click mailbox-general-Alias- i need alias names
and email addresss-i can see mutliple email addresses
i.e SMTP:roger.federer@mydomain.com
SMTP:roger.f@mydomain.com
i want to sort all these

vasilmichev · Answer

Not really sure what you mean, but assuming I got it right, try this:
&nbsp;
Import-csv blabla.csv | % { Get-Mailbox $_.SMTP&nbsp;| select Alias, EmailAddresses }
&nbsp;
If you want a detailed report of all aliases in your domain, you can use this script: https://gallery.technet.microsoft.com/Office-365-aliases-b3937767?redir=0

roger roger · Answer

Hi i have used the below syntaxImport-csv C:\emails.csv | % { Get-Mailbox $_.SMTP | select Alias, EmailAddresses }in emails.csv files i have email addresses in the below format,i have tested with 2 emails in csv fileuser1@mydomain.comuser2@mydomain.comThe output i am getting is for all the email addresses it is not picking from the csv file.i only want to pull the report from csv fileAlias &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; EmailAddresses----- &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; --------------user1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {smtp:user1.test@mydomain.com, SMTP:user1@mydomain.com}user2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {smtp:user2.test@mydomain.com, SMTP:user2@mydomain.com}user4 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {SMTP:user4@mydomain.com}user5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {SMTP:user5@mydomain.com}user6 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {SMTP:user6@mydomain.com}user7 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {SMTP:user7@mydomain.com}user8 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {SMTP:user8@mydomain.comAnd also i am not able to export to proper format when i tried below syntaxImport-csv C:\emails.csv | % { Get-Mailbox $_.SMTP | select Alias, EmailAddresses } | export-csv C:\output.csv -NoTypeInformation

roger roger · Answer

even i tried the below syntax, i am not getting alias name and i am getting output for only the first email id in csv file

for example in emails.csv i have user1@mydomain.com and user2@mydomain.com, i am getting output for first email id.

$users=import-csv C:\emails.csv
ForEach($user in $users){
Get-Recipient $user.email | Select Name -ExpandProperty EmailAddresses |export-csv C:\output.csv -notypeinformation
}

vasilmichev · Answer

Well I cannot guess what you have in the CSV, my example above assumes that all the addresses are under a column named "SMTP". If you are using another name, simply replace it accordingly. Or use the script I linked to.

Forum Discussion

alias

4 Replies

Resources