It appears the usage of Grafana APMSQL is limited to only pulling in a single agent and the metrics for that specific agent. Are there any future updates that may expand this to pull in multiple agents and metrics with APMSQL Grafana?
I'm trying to duplicate my Dashboards with Grafana and seeing this isn't going work, as the APM SQL only pulls in one match when using regex for the Agent. I don't even know which agent it pulled back as it doesn't show the agent information either.
This example dashboard show my MOM & Collectors and their Heap usage.
When I try to duplicate this in Grafana, the APMSQL for the Collectors only returns 1 agent, which I don't even know which one it is: