How to use SWQL for create KPI Widgets

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'

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')

Thank You 

Thank You