wow, is this not possible?? Or am I asking is the wrong place. can't imagine this issue has not been addressed before!

ttt

Thanks Eirikur

I think the gateway is sys.dm_os_hosts. Any further insights from the community on dm_os_hosts and distributed queries?