• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 428
  • Last Modified:

Script to detail DAG mount status

We have about 100 DB's in our DAG. Each DB can be on one of 5 Exchange 2010 mailbox servers.

I would like a script that would tell me which server the DB's are mounted on and output this to an Excel sheet.

Does anyone know if this is possible?
0
smith1974
Asked:
smith1974
  • 2
1 Solution
 
AnuroopsunddCommented:
Get-DatabaseAvailabilityGroup | Get-ExchangeServer | Get-MailboxDatabase

Get-exchangeserver | Where {$_.AdminDisplayVersion -Like "Version 14*" -and $_.ServerRole -Like "Mailbox*"} | SORT | get-mailboxdatabase | sort identity -unique | ft identity,Server,ActivationPreference -auto

 http://powershell.com/cs/forums/p/6441/10538.aspx


http://www.open-a-socket.com/index.php/2012/02/28/powershell-script-to-log-dag-database-queues-to-file/
0
 
AnuroopsunddCommented:
Get-MailboxDatabase -Status | select Name, server, storagegroup, mounted

reult as below
Name                          Server                        StorageGroup
----                               ------                          ------------
MailDatabase              EXCH07                        EXCH07\Test1
MDB01                         EXCH07                        EXCH07\SG1
MDB02                         EXCH071                      EXCH071\SG2

 http://powershell.com/cs/forums/p/7343/11957.aspx
0
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.

Join & Write a Comment

Featured Post

Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now