proxyoverviewreport

SELECT prx.mgm_id,

    prx.system_id AS proxy_id,

    prx.hostname AS proxy_name,

    sys.hostname AS system_name,

    sys.system_id,

    prx.synced_date

   FROM (system prx

     JOIN system sys ON (((sys.proxy_system_id = prx.system_id) AND (sys.mgm_id = prx.mgm_id))))

  WHERE prx.is_proxy

  ORDER BY prx.mgm_id, prx.system_id, sys.system_id;