A reader asks whether it is possible to run a PowerShell command to list the active database copies in a database availability group, and show the mailbox server that they are active on.
He’s already discovered the Get-MailboxDatabaseCopyStatus cmdlet, but the default output does not include the specific information he wants to see.
[PS] C:\>Get-MailboxDatabaseCopyStatus * | ft -auto Name Status CopyQueueLength ReplayQueueLength LastInspectedLogTime ContentIndexState ---- ------ --------------- ----------------- -------------------- ----------------- DB01EX2013SRV1 Mounted 0 0 Healthy DB02EX2013SRV1 Healthy 0 0 15/10/2014 10:31:16 AM Healthy DB03EX2013SRV1 Mounted 0 0 Healthy DB04EX2013SRV1 Mounted 0 0 Healthy DB02EX2013SRV2 Mounted 0 0 Healthy DB01EX2013SRV2 Healthy 0 0 15/10/2014 10:25:33 AM Healthy DB03EX2013SRV2 Healthy 0 0 15/10/2014 10:25:30 AM Healthy DB04EX2013SRV2 Healthy 0 0 15/10/2014 10:27:34 AM Healthy
The information he is looking for can be retrieved using Get-MailboxDatabaseCopyStatus, we just need to use Select-Object to return different attributes than the default output displays.
Let’s say you wanted to see:
- Active mailbox database copies only, and their status for good measure
- The mailbox server they are active on (even though this is already in the name of the DB copy we’ll grab it separately as well)
- The activation preference of that database copy
- The content index state
To see all of that we can run this command:
[PS] C:>Get-MailboxDatabaseCopyStatus * -Active | Select Name,Status,MailboxServer,ActivationPreference,ContentIndexState Name Status MailboxServer ActivationPreference ContentIndexState ---- ------ ------------- -------------------- ----------------- DB01EX2013SRV1 Mounted EX2013SRV1 1 Healthy DB03EX2013SRV1 Mounted EX2013SRV1 1 Healthy DB04EX2013SRV1 Mounted EX2013SRV1 1 Healthy DB02EX2013SRV2 Mounted EX2013SRV2 1 Healthy
If you’re curious about other attributes that can also be viewed simply use Get-Member to list them all.
[PS] C:>Get-MailboxDatabaseCopyStatus | Get-Member
[adrotate banner=”49″]
How do I get the command Get-MailboxDatabaseCopyStatus * | ft -auto to forward respond to my email
Is there a way to determine how many databases are replicating the same information across too many databases? I don’t want to sound too technical but a lot of small details like replication time can interfere with name changes or old forms that get handled by too many people who don’t have a good view of where to retrieve old records.
Hi Paul,
I have exchange 2013
I don’t want to look at the properties of each account to see if they are using our first, Second or third database. Could you show me the command to list users in a specific database?
Hi Paul,
we have exchange 2013 CU 10 with windows Server 2012. Since yesterday one of our exchange 2013 DAG member shows unavailable network in its DAG network details. Both MAPI and REPL networks are shown unavailable.
$_.Status -ne ‘Mounted’ can you guide me what does -ne means here in this command
The Real Person!
Author Paul Cunningham acts as a real person and passed all tests against spambots. Anti-Spam by CleanTalk.
It’s a conditional operator that means “not equal”.
So the command should return databases that do not have a status of “Mounted”.
can i do email forwarding on Distribution group to user’s mailbox?
To get the list of Active DB (Mounted) on a Exchange server, this is the command.
Get-MailboxDatabaseCopyStatus -Server | Where-object { $_.status -eq “mounted”}
The Real Person!
Author Paul Cunningham acts as a real person and passed all tests against spambots. Anti-Spam by CleanTalk.
No need for that when you can just use the -Active switch.
-Active switch will also give you the Dismounted DB. Which is not good for Backup Software.
HI,
We need a powershell script to list ACTIVE database name but only on the local server. We need to say the ACTIVE database name for the backup software.
This will also work
Get-MailboxDatabaseCopyStatus -server SERVERNAME | Where {$_.ActivationPreference -eq 1} | select Name,Status,CopyQueueLength,ReplayQueueLength,ContentIndexState | ft
Hi Paul ,
Thanks a lot for your response .
S.Nithyanandham
Hi Paul ,
Does the below mentioned single command gives the list the active database copies in a database availability group, and show the mailbox server that they are active on for the environment which is having multiple no of DAG’S ?
Get-MailboxDatabaseCopyStatus * | ft -auto
The Real Person!
Author Paul Cunningham acts as a real person and passed all tests against spambots. Anti-Spam by CleanTalk.
It will return all database copies in the org, even for multiple DAGs.
Thanks for the clarification. Will post on any doubt in feature..