This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Agent Status Report

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:

pastedImage_3.png

Parents
  • This is a normal warning message you can expect when using any aggregate function (SUM, MAX, etc).  However, you can eliminate it in a script by preceding it with

    SET ANSI_WARNINGS OFF;  which you can place in the report sql query.

Reply
  • This is a normal warning message you can expect when using any aggregate function (SUM, MAX, etc).  However, you can eliminate it in a script by preceding it with

    SET ANSI_WARNINGS OFF;  which you can place in the report sql query.

Children
No Data