The Network Wide Availability is the available (ICMP) of all devices over a 30 minute average. It would have been more useful with the ability to filter in just the nodes we need to see. The 30 minute average resolution is not all that helpful.
I have replicated it using SWQL and increased the resolution to 10 minute average plus the ability of filtering.
SELECT
adddate('millisecond',0,concat(year(n.ResponseTimeHistory.DateTime),'-', substring(concat('0',month(n.ResponseTimeHistory.DateTime)),length(concat('0',month(n.ResponseTimeHistory.DateTime)))-1,2),'-',substring(concat('0',day(n.ResponseTimeHistory.DateTime)),length(concat('0',day(n.ResponseTimeHistory.DateTime)))-1,2),' ',substring(concat('0',hour(n.ResponseTimeHistory.DateTime)),length(concat('0',hour(n.ResponseTimeHistory.DateTime)))-1,2),':',substring(concat('0',(MINUTE(n.ResponseTimeHistory.DateTime)/10)*10),length(concat('0',(MINUTE(n.ResponseTimeHistory.DateTime)/10)*10 ))-1,2),':00' )) as SumDate
,round(avg(n.ResponseTimeHistory.Availability),2) as [Network]
,'Availability' as [t]
from orion.nodes n
where hourDIFF(n.ResponseTimeHistory.DateTime,GETDATE()) <=24
--and (n.vendor in ('Broadcom Corporation','Brocade Communications Systems, Inc.','Check Point Software Technologies Ltd','Cisco','F5 Networks, Inc.','F ortinet, Inc.','Juniper Networks/NetScreen','SonicWALL, Inc.')
group by concat(year(n.ResponseTimeHistory.DateTime),'-', substring(concat('0',month(n.ResponseTimeHistory.DateTime)),length(concat('0',month(n.ResponseTimeHistory.DateTime)))-1,2)
,'-',substring(concat('0',day(n.ResponseTimeHistory.DateTime)),length(concat('0',day(n.ResponseTimeHistory.DateTime)))-1,2),' '
,substring(concat('0',hour(n.ResponseTimeHistory.DateTime)),length(concat('0',hour(n.ResponseTimeHistory.DateTime)))-1,2),':'
,substring(concat('0',(MINUTE(n.ResponseTimeHistory.DateTime)/10)*10),length(concat('0',(MINUTE(n.ResponseTimeHistory.DateTime)/10)*10 ))-1,2),':00'
)
order by [SumDate]
Thank you
Amit
email: ashah@loop1.com
Loop1 Systems - SolarWinds Training and Professional Services
