Replicate the connected agents report in Insight?

Hello all,

I would like to pull a list of each APM Agent with it’s connected hosts very similar to the canned report you can find at Account Settings\Connected Agents. I can’t use the canned report because it truncates the hosts after 3 entries. is there anyway to pull together this information in Insights or elsewhere within the application?

Hi, @Phil.Carroll: You might try something like this:

SELECT count(*) 
FROM NrDailyUsage 
WHERE productLine = 'APM' 
SINCE 1 DAY AGO 
FACET apmAppName, agentHostname, apmLanguage, apmAgentVersion 
LIMIT 1000
1 Like

That’s super helpful! Would it be at all possible to pull in the infrastructure agent version of the hosts if it’s installed as well?

Thanks!

You can, but the data looks a bit funky. Because APM and Infrastructure data are sent to Insights in separate events, APM and Infra agent info are displayed on separate rows:

SELECT count(*) 
FROM NrDailyUsage 
WHERE productLine IN ('APM', 'Infrastructure') 
SINCE 1 DAY AGO 
FACET apmAppName, agentHostname, apmLanguage, apmAgentVersion, infrastructureAgentVersion 
LIMIT 1000

I would probably use separate queries, one for APM, another for Infra.

2 Likes