I'd like to create a table with servers over a certain % CPU

  • What Grafana version and what operating system are you using?
    I’m using Grafana version 8.4.7 and looking at both Linux (node exporter) and Window (winexporter) metrics

  • What are you trying to achieve?
    I’m trying to create a list of servers that are at or above a threshold over time.
    For instance I want to see which servers hit a 90% or more CPU spike in the last 30 days. I can certainly see specific servers usage over the last 30 days and chart when it hit 90% CPU but I need to know the name of the server. What I want is sort of the reverse. Give me all my servers but filter out only those that hit 90% CPU usage and show me those dates.

  • How are you trying to achieve it?
    I’ve tried various different queries and they get close but I"ve not been able to filter a list and I have all the servers listed.

I’ve been looking around the forums looking for anything that will show me how to create a filtered list but so far have been unsuccessful.

1 Like

Hi @billycote it would be helpful if you could include the query that you used, what it returned, and how you’d like to further trim it down. What have you tried so far?

Is the issue with the query returning too much data, or with the visualization showing the right subset of data? Screenshots can help.