fetch connected hosts count to each active gate and display trends with DQL

[Sisapy09]

any have DQL to get the some upgrade problems and hosts connected to AG. we can see them in deployment page but just checking if possible to get that from DQL.

[sujit_k_singh]

@Sisapy09 

You can’t pull the exact “currently connected hosts per ActiveGate” via DQL today. That counter is shown on the Deployment Status page, but there’s no exposed metric for it in Data Explorer/DQL. The closest metric is the self‑monitoring one for connected OneAgent modules, which you can trend and split by ActiveGate

Solved: hosts connected to each AGs - Dynatrace Community

If you really need the host count per AG, the workaround is to call the ActiveGates API (getAllActiveGates) and read connectedHosts, then surface that in a dashboard app/notebook. There’s a community thread with a small JS example that does exactly this

List of Hosts connected to an ActiveGate - Dynatrace Community