Read only routing list - UI by Billy_La

Since Read_Only_Routing is getting more and more important, an user interface for this topic, would be very helpful.
I'm refering especially to viewing/crosschecking the already configured ROR, maybe with an edit option.

As an example:


    select
    ag.name,
    stat.replica_server_name as if_server_primary,
    lis.routing_priority,
    stat2.replica_server_name as read_only_server,
    ar.read_only_routing_url as read_only_routing_url
from sys.availability_read_only_routing_lists lis
inner join sys.dm_hadr_availability_replica_cluster_states stat ON lis.replica_id=stat.replica_id
inner join sys.availability_groups ag on stat.group_id=ag.group_id
inner join sys.dm_hadr_availability_replica_cluster_states stat2 ON lis.read_only_replica_id=stat2.replica_id
inner join sys.availability_replicas ar on lis.read_only_replica_id = ar.replica_id
order by if_server_primary, routing_priority