Simple Average Node Availability Dashboard

mcgreen1966

Hi i want to create a dashboard with a pie chart or percentage number, to display the average availability of all the nodes i have in my solarwinds system

I can easily run a report to do this. but i would like a dashboard to show this information.

is there anyway to do this ?

Cheers

Mark

mesverrum

Orion has a distinct lack of pie charts, there are only 2 I can think of off the top of my head in the tool natively, and neither of them are customizable in any way.  For people who NEED pie charts they usually just end up building javascript in the custom html resource, or we settle on doing it with SWQL queries like this one

SELECT Count(*) as TOTAL

,'/Orion/images/StatusIcons/ContainerMembers/DefaultIcon.gif' as [_iconfor_TOTAL]

,(SELECT Count(*) as UP FROM Orion.Nodes Where Status = 1) as UP

, '/Orion/images/StatusIcons/Small-Up.gif' as [_iconfor_UP]

,(SELECT Count(*) as DOWN FROM Orion.Nodes Where Status = 2) as DOWN

,'/Orion/images/StatusIcons/Small-Down.gif' as [_iconfor_DOWN]

,(SELECT Count(*) as UNMANAGED FROM Orion.Nodes Where Status = 9) as UNMANAGED

,'/Orion/images/StatusIcons/Small-Unmanaged.gif' as [_iconfor_UNMANAGED]

,(SELECT Count(*) as OTHER FROM Orion.Nodes Where Status not in (1,2,9)) as OTHER

,'/Orion/images/StatusIcons/Small-NotRunning.gif' as [_iconfor_OTHER]

FROM Orion.Nodes