Hello, I would like to request that an item be implemented to identify which proxy monitors each host. It should also take into account if the host is monitored by a Proxy Group.

Currently, we use the following query in the database to determine which proxy monitors each host.

This is important for us because we use the Proxy Group, and if there is any connectivity issue, it is easy to determine if the host was being monitored by one proxy and has been changed to another.

SELECT 
    h.host AS "hostname",
    COALESCE(p1.name, p2.name) AS "proxyname"
FROM 
    hosts h
LEFT JOIN 
    proxy p1 ON h.proxyid = p1.proxyid
LEFT JOIN 
    host_proxy hp ON h.hostid = hp.hostid
LEFT JOIN 
    proxy p2 ON hp.proxyid = p2.proxyid
WHERE 
    h.proxyid IS NOT NULL OR hp.proxyid IS NOT NULL
ORDER BY h.host