I am needing a SWQL query for a KPI widget on a modern dashboard
Looking to get a count of Nodes that a UP that the CPU is running at or higher than 90% for over an hour
Then I would like it to filter that count by a Custom Properties
It's doable but I'm not going to find the time to write it anytime soonIf you're doing it in pure swql you're dealing with timeseries data, that's where to start
If thats a pain, you could set an alert (doesnt need to do anything) for that condition, then report on the alert.