This script lists and gets the size of the Exchange databases
Script :
Get-MailboxDatabase -Status | select Name,DatabaseSize| Out-GridView
Reference
Get-MailboxDatabase
This cmdlet is available only in on-premises Exchange Server 2013.
Use the Get-MailboxDatabase cmdlet to retrieve one or more mailbox database objects from a server or organization.
Detailed Description
If you use the Get-MailboxDatabase cmdlet with no parameters, it retrieves information about all mailbox databases in the Exchange organization. If you use the Get-MailboxDatabase cmdlet with the Server parameter, it retrieves information about all mailbox databases on the server that you specify.
The following list describes the properties that are returned in the results.
- Name Name of the database.
- Server Server hosting the database.
- Recovery Specifies whether the new database is designated as a recovery database.
- ReplicationType Replication type of the database.
You need to be assigned permissions before you can run this cmdlet. Although all parameters for this cmdlet are listed in this topic, you may not have access to some parameters if they’re not included in the permissions assigned to you. To see what permissions you need, see the “Mailbox Database Permissions” section in the Recipients permissions topic.
Parameters
| Parameter | Required | Type | Description |
|---|---|---|---|
| Server | Required | Microsoft.Exchange.Configuration.Tasks.ServerIdParameter | The Server parameter specifies the name of the server from which to retrieve mailbox database information. If you specify this parameter, the command retrieves information about all of the mailbox databases on the server that you specify. |
| DomainController | Optional | Microsoft.Exchange.Data.Fqdn | The DomainController parameter specifies the fully qualified domain name (FQDN) of the domain controller that retrieves data from Active Directory. |
| DumpsterStatistics | Optional | System.Management.Automation.SwitchParameter | The DumpsterStatistics switch specifies that transport dumpster statistics be returned with the database status. |
| Identity | Optional | Microsoft.Exchange.Configuration.Tasks.DatabaseIdParameter | The Identity parameter specifies a mailbox database. You can use the following values:
If you have multiple databases with the same name, the command retrieves all databases with the same name in the specified scope. |
| IncludePreExchange2013 | Optional | System.Management.Automation.SwitchParameter | The IncludePreExchange2013 switch parameter specifies whether to return information about the mailbox databases that reside on computers running Microsoft Exchange Server 2013 and earlier versions of Exchange. |
| Status | Optional | System.Management.Automation.SwitchParameter | The Status switch specifies whether to retrieve the available free space in the database root and information about the following attributes:
You don’t need to specify a value with this switch. If you specify this switch, you should format the output in such a way that you can view the additional attributes, for example, pipe the output to the Format-Listcmdlet. |