What would you like to be added:
Identify if a database is in an AlwaysOn Availability Group, and what its status is (primary/secondary/etc.)
Why is this needed:
Need to ensure we do not size passive copies of databases.
Also need to distinguish when there are databases with the same name on different servers that do need to be protected. I.e. "DB1" on servers "DB1-Prod", "DB1-Dev", etc.
What would you like to be added: Identify if a database is in an AlwaysOn Availability Group, and what its status is (primary/secondary/etc.) Why is this needed: Need to ensure we do not size passive copies of databases.
Also need to distinguish when there are databases with the same name on different servers that do need to be protected. I.e. "DB1" on servers "DB1-Prod", "DB1-Dev", etc.
Additional context