<div>
Name the header of the .csv file Emailaddress <br />
Open up your Exchange Management Shell and run the below command<br />
Import-Csv 'yourfilelocation\filename<wbr />.csv' | %{Get-Mailbox $_.Emailaddress | Select DisplayName, Alias, Database} | Export-Csv 'yourfilelocation\filename<wbr />.csv' -notypeinformation
</div>


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

<div>
thank you so much fox, i get the output <br />
<br />
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<br />
<br />
Import-Csv c:\temp.csv | %{Get-Mailbox $_.DisplayName | Select EmailAddress, Alias, Database} | Export-Csv c:\tempoutput.csv -notypeinformation
</div>


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

<div>
<div class="content wysiwyg-content">
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
</div>
</div>


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

Power Shell Script for exchange 2010

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.

Powershell

Exchange is the server side of a collaborative application product that is part of the Microsoft Server infrastructure. Exchange's major features include email, calendaring, contacts and tasks, support for mobile and web-based access to information, and support for data storage.

Exchange

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.