Query Servers Agent Installed

hi everyone… I inherited about 200 Virtual Windows Servers, some have RelicOne Agent installed and others do not. Is there an easy way to query a bunch of servers to pull if RelicOne Agent is installed on them and export the results to a CSV file?

Hi, @erasmo.medina:

SELECT uniques(hostname) FROM SystemSample LIMIT MAX

will give you a list of hosts with an Infrastructure agent reporting to New Relic. If the agent is not installed, New Relic won’t know anything about them; there is no way to query New Relic for hosts that are not reporting to it. :slight_smile:

Instructions to export CSV are here: Import, export, add, and share dashboards and charts | New Relic Documentation.