Select Page

Exchange DAG database activation report

Exchange DAG database activation report
Advertisement

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.

About The Author

Ammar Hasayen

Ammar is a digital transformer, cloud architect, public speaker and blogger. He is considered a trusted advisory with the ability to quickly navigate complex multi-cultural organizations and continuously improve and motivate cross-functional teams to achieve higher productivity, collaboration, revenue gain and cross-group knowledge sharing. His contributions to the tech community helped him get awarded the Microsoft Most Valuable Professional. Ammar appears in a lot of global conferences, and he has many publications about digital transformation and next generation technologies.

3 Comments

  1. Duane

    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

    Reply
    • ammar hasayen

      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.

      Reply
      • Duane

        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!

        Reply

Leave a reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Hi, I’m Ammar Hasayen

Ammar-New-MVP

About Me

Cloud Architect | Cybersecurity | CISSP | Microsoft MVP | Pluralsight Author | Book Author | International Speaker | World Explorer | @ammarhasayen

 

LinkedIn Profile

My Pluralsight Course

Speaking at Microsoft Ignite Dubai

Ammar Hasayen Speaker Ignite

Pin It on Pinterest