I have created a report to display most of the various issues that an agent can have so that remediation steps can be taken. This is a work in progress, so feel free to make suggestions. I split up the query and created a view in the Orion database to make the editing simpler, but this works too.
HostName - Enable Details Page Link
Status - Enable Status Icon
StatusDescription - Allow HTML tags
CPU - Percentage bar
Mem - Percentage bar
Blank field for memory used - Set the data unit to allow MB
The resultant query allows the following report: