How to use SWQL for create KPI Widgets

Question

How to use SWQL for create KPI Widgets 
 1. Count All Interface node A,B,C 
 2. C ount All Interface node A,B,C Status Up 
 3. Count All Interface node A,B,C Status Down 
 
 Example

edwinhoekman · Answer

I would suggest to use one of the following swql statments If you want to have one tile for Node A,B,C use the following statment fur up interfaces, For down interfaces just set the OperStatus =2 SELECT count(1) As [Status]
FROM Orion.NPM.Interfaces AS [Interf]

WHERE [Interf].OperStatus =1
AND [Interf].Node.Caption IN ('A','B','C') 
 
 For a tile per Node: SELECT count(1) As [Status]
FROM Orion.NPM.Interfaces AS [Interf]

WHERE [Interf].OperStatus =1
AND [Interf].Node.Caption = 'A' And if you know the Node ID: SELECT count(1) As [Status]
FROM Orion.NPM.Interfaces AS [Interf]

WHERE [Interf].OperStatus =1
AND [Interf].Nodeid = <Fill the node id Number> 
 
 And to count all interfaces just replace WHERE [Interf].AdminStatus =1
AND [Interf].Node.Caption IN ('A','B','C') 
 By WHERE [Interf].Node.Caption IN ('A','B','C')

l.mendoza · Answer

Hi, try this. Hope this help.

How to use SWQL for create KPI Widgets

Top Replies