Nodes Total, Down, Up

Question

Hi,

I'm looking for something to stick on the home page above the Network Map that states "Total number of nodes" followed by "Number Of Nodes Down" and Number Of Nodes Up" I'd like it to be in one resource. I've VERY little experiance with SQL queries and so far all I've come up with is a report that shows number of nodes either up or down but no idea how to put them into one. Any taughts or suggestions appreciated.

Thanks.

LadaVarga · Accepted Answer

Hello,

Add Custom query resource:

and Add this to that resource:

select S.ShortDescription as Status, count(N.status) as number from Orion.nodes as N

left join Orion.StatusInfo as S on S.Statusid=N.Status

group by S.ShortDescription

Probably someone can tune this.

thanks

Nodes Total, Down, Up

Top Replies