Exchange DAG database activation report

One of the most wanted reports for Exchange admins is the ability to see how their databases are distributed across mailbox servers, and whether their activation preferences settings are respected. They want to know if their databases are mounted on the preferred mailbox server. DAG database activation report is generated via a script that will go through your Exchange environment, collect activation preferences, and draw a layout table for you, showing where each database is mounted, and whether this is the preferred server for that.

At the end, the script will automatically send you an email with HTML table that summarize all your DAG objects, and for each DAG, it will list all databases in the DAG and mailbox servers participating in that DAG. Highlighting and numbering will reflect activation preference and at the end you will get a summary of total copies and mounting status.

Do you remember Ross Smith’s excel sheet in the famous Exchange calculator. There is a part where the calculator will give you an excel table with database distribution. Well, this is exactly the same, but with real data.

DAG database activation 1

Exchange DAG database activation report HTML table:

  • Yellow Cells : database is mounted on this server and this server happen to be the Activation preference = 1 for that database
  • Red Cells : database is mounted on this server and this server happen to be the Activation preference not = 1 for that database
  • Green Cells: The server is hosting a copy of that database
  • Total Copies: Total number of database copies on that server
  • Ideal Mounted DB Copies: according to your activation preference, how many database copies should be mounted on that server
  • Actual Mounted DB Copies: actual number of databases mounted on this server at tun time

 Release notes

Just download the Exchange DAG database activation report script and run it. The script needs only Exchange PowerShell. The account which runs the script should be at least member of the Exchange View Administrators (read access only). Modify the script’s SMTP settings to receive the output HTML Table via email.