Is there a way to run a report to show all nodes that have an average CPU load of 80% or greater for longer then 2 hours?
Creating an alert for the 80% criteria with a 'condition must exist for ...' option might be an easy way to handle this, since that functionality is built into the alerting. Your report could be done from the perspective of alerting.
I would think any other approach would involve lots of SQL / SWQL pretty fast. Unless I'm overlooking something. Others more capable in SQL / SWQL would probably have a different solution.
create custom table report.
edit table items
I changed that CPU load value to 30 to get some results, .. its will be like this,
And if you want, avg cpu load greater for longer than 2 hours,that feature is in alerting not in reporting. But you can achieve this by SQL query.