cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 12

NPM - Network Wide Availability (swql)

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.

cscoengineer_0-1594954855079.png

I have replicated it using SWQL and increased the resolution to 10 minute average plus the ability of filtering.

cscoengineer_1-1594954952751.png

 

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

Labels (3)
1 Reply
Level 16

Great report! Thanks for sharing it. 

0 Kudos