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.
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.
Great Script….
I just noticed that yours shows the databases sorted in order….when the report runs for me it doesn’t sort them. Is this a easy change? add in the line a -sort command?
Thanks
Duane
Hi..can you check if the output is sorted by databases hosted in the same server? I guess thats the point right? When designing the script, its about DB distribution for each server, so it makes sense to output them that way.
Actually you are right! We are in the process of maintenance of whitespace and all that fun stuff on the databases. So everything looked off! Thanks again!