I'm using this query "Config.MapMirror.List" To get information of the list of servers that are in the mirror system.
I'd like to know how can I know which of the list is the primary and which is the failover or async member.
Is there a way to do it with this query? Is there another query to get this info?
Thanks a lot