KPIs for network

masroor.khan

Hi,

I need help on SQL commands to get the results to create KPI dashboard for  "Network Devices availability " WAN interfaces downtime" and :"Network Latency & Packet loss"

Thanks 

bobmarley

We use custom properties, but in the Where Clause you could use Vendor instead out of the Nodes table. I don't have one for Wan Interfaces

Nodes that are up Total - Edit the Where to your environment.

SELECT 
COUNT(Status) as StatusCount
from orion.nodes n
Where ((TOUPPER([N].CustomProperties.YOURCUSTOMPROPERTYNAME) ='YOURCUSTOMPROPERTYVALUE%') OR Category=1) and [N].Status= 1

Average Uptime

SELECT 
ROUND(AVG([N].ResponseTimeHistory.Availability),3) as AvgTime
from Orion.Nodes [N]
Where ((TOUPPER([N].CustomProperties.YOURCUSTOMPROPERTYNAME) ='YOURCUSTOMPROPERTYVALUE') OR Category=1)

Average Loss

SELECT

  ROUND(AVG([N].PercentLoss),2) as AverageLoss

FROM Orion.Nodes N

Where ((TOUPPER([N].CustomProperties.YOURCUSTOMPROPERTYNAME) ='YOURCUSTOMPROPERTYVALUE') OR Category=1) 

Average MS

SELECT

  ROUND(AVG([N].ResponseTime),2) as ResponseTime

FROM Orion.Nodes N
Where ((TOUPPER([N].CustomProperties.YOURCUSTOMPROPERTYNAME) ='YOURCUSTOMPROPERTYVALUE') OR Category=1)