1
SELECT prx.mgm_id,
2
prx.system_id AS proxy_id,
3
prx.hostname AS proxy_name,
4
sys.hostname AS system_name,
5
sys.system_id,
6
prx.synced_date
7
FROM (system prx
8
JOIN system sys ON (((sys.proxy_system_id = prx.system_id) AND (sys.mgm_id = prx.mgm_id))))
9
WHERE prx.is_proxy
10
ORDER BY prx.mgm_id, prx.system_id, sys.system_id;