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.

Node_Status_Summary.png

Node Status Summary Resource/Widget.  To create:

1) Edit the Summary Page you are on

2) Add Widget --> Custom Query

3) Save the page

4) Edit the Custom Query Resource/Widget

5) Change the name to "Node Status Summary", and use the following query:

select case Status

when 1 then 'UP'

when 2 then 'DOWN'

when 3 then 'WARNING'

when 11 then 'External'

when 14 then 'Critical'

else 'Other' end as Current_State,

Count(Status) as Number

from Orion.Nodes group by Status order by Status

6) Submit, and voila! You should have something similar to the picture posted here.

I will work on making this prettier if I can later.  I'll edit this post if/when I do.