I just started playing with the 10.7 SP2 with Grafana and Tomcat. I have it up and working and I can pull data.
My question is though, is it limited in design to build dashboards for 1 Agent and display multiple metrics for that 1 Agent? When I code this up, it work well and my simple regex can grab a lot of metrics for that 1 Agent.
I was trying to build one that would display multiple agents and 1 metric for all my agents. I cannot seem to get this to load and I know I have the APMSQL correct, with a simple regex to match multiple agents and only the 1 metric.
Remember the data collection is not instantaneous requires some time before it can be displayed.
I believe the issue is the agent name isn't being used to make it unique, so all the metrics returned have the same name. I'm just trying to confirm I'm not missing something obvious.
Not sure if relevant to your symptoms and just in case you were not aware, for Grafana queries the <agent specifier regex> is limited to agent_name and not the usual 'agent_host|agent_process|agent_name'.
This came out in this recent Community thread: No data points (grafana+apmsql) and I wrote this KB: CA APM Grafana APMSQL queries - CA Knowledge