Power Shell Script for exchange 2010

i have list of users email address in a csv file and i need to get their database name in the csv file using powershell script
abdull sheriffSystems EngineerAsked:
Who is Participating?
FOXActive Directory/Exchange EngineerCommented:
Pardon my syntax, let's go for it again.

Import-Csv 'yourfilelocation\filename.csv' | %{Get-Mailbox $_.DisplayName | Select DisplayName, Alias,PrimarySmtpAddress, Database} | Export-Csv 'yourfilelocation\filename.csv' -notypeinformation
FOXActive Directory/Exchange EngineerCommented:
Name the header of the .csv file Emailaddress
Open up your Exchange Management Shell and run the below command
Import-Csv 'yourfilelocation\filename.csv' | %{Get-Mailbox $_.Emailaddress | Select DisplayName, Alias, Database} | Export-Csv 'yourfilelocation\filename.csv' -notypeinformation
abdull sheriffSystems EngineerAuthor Commented:
thank you so much fox, i get the output

But when i have a csv file with DisplayName and when i run the below script i get the details of Alias and Database but not the emailaddress, the email address is blank

Import-Csv c:\temp.csv | %{Get-Mailbox $_.DisplayName | Select EmailAddress, Alias, Database} | Export-Csv c:\tempoutput.csv -notypeinformation
abdull sheriffSystems EngineerAuthor Commented:
thank you so much
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.