I am looking for a report that will show nodes that have hit the warning/critical threshold for CPU and Memory 5 times in a day for the last 7 days.
Is this possible ?
Using the AlertHistory or events table, you could create a query using the 'COUNT' operation to accumulate the number of 'CPU/Memory High utilization' alerts triggered for nodes, in your case specifically servers. You could then create a condition in the query to only display this data IF 'number of alerts' > 5. You would also be able to define that the query only pull back data which is from the last 7 days using the field which defines when the alert was triggered.Does this sound viable? I haven't tried doing this myself but I would be interested to see if you can make it
This worked. Thank you!
Nice don't suppose you have any other ideas or a copy of the query?