<div>
Try this:<br />
<br />
Get-MailboxDatabase -Status | select ServerName,Name,DatabaseSi<wbr />ze,Availab<wbr />leNewMailb<wbr />oxSpace | Sort -property AvailableNewMailboxSpace -Descending
</div>


Try this:

Get-MailboxDatabase -Status | select ServerName,Name,DatabaseSize,AvailableNewMailboxSpace | Sort -property AvailableNewMailboxSpace -Descending

<div>
exactly what i was looking for!!! thanks
</div>


<div>
<div class="content wysiwyg-content">
i have the following script to get the DB's in a DAG <br />
<br />
Get-MailboxDatabase -identity EXCHdb* -Status | select ServerName,Name,DatabaseSi<wbr />ze,Availab<wbr />leNewMailb<wbr />oxSpace | Sort-Object AvailableNewMailboxSpace<br />
<br />
result is sorted by AvailableNewMailboxSpace .... <br />
<br />
need to extract the largest value and grab the name of DB<br />
<br />
how do i pipe that ?
</div>
</div>


i have the following script to get the DB's in a DAG 

Get-MailboxDatabase -identity EXCHdb* -Status | select ServerName,Name,DatabaseSize,AvailableNewMailboxSpace | Sort-Object AvailableNewMailboxSpace

result is sorted by AvailableNewMailboxSpace .... 

need to extract the largest value and grab the name of DB

how do i pipe that ?

Sorting data in Exchange powershell to extract the largest value

Active Directory (AD) is a Microsoft brand for identity-related capabilities. In the on-premises world, Windows Server AD provides a set of identity capabilities and services, and is hugely popular (88% of Fortune 1000 and 95% of enterprises use AD). This topic includes all things Active Directory including DNS, Group Policy, DFS, troubleshooting, ADFS, and all other topics under the Microsoft AD and identity umbrella.

Active Directory

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

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.