Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

How to use SWQL for create KPI Widgets

oztsi

1. Count All Interface node A,B,C

2. Count All Interface node A,B,C Status Up

3. Count All Interface node A,B,C Status Down

Example

Find more posts tagged with

Accepted answers

All comments

l.mendoza

Hi, try this. Hope this help.

edwinhoekman

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 =

And to count all interfaces just replace

WHERE [Interf].AdminStatus =1
AND   [Interf].Node.Caption IN ('A','B','C')

WHERE [Interf].Node.Caption IN ('A','B','C')

Thank You

Thank you

I am stuck in SWQL query as mentioned below. I am not good in query. Can u please help to fix the below query.

SELECT n.Caption,n.IP_Address,n.Status,n.DetailsUrl
FROM Orion.Nodes n
WHERE (Caption LIKE '%GRCRY%')

I want to monitor those nodes which is polling through the ICMP only.

edwinhoekman

Hi @ImNishat ,

Are you looking for something like:

SELECT [n].Caption,[n].IP_Address,[n].Status,[n].DetailsUrl
FROM Orion.Nodes AS [n]
WHERE [n].Caption LIKE '%GRCRY%' AND [n].ObjectSubType = 'ICMP'

ImNishat

Hi @edwinhoekman

Thanks for your quick response and it's working as expected. Need one more modification in this, please see the snapshot of the result as shown below.

I would like to add an additional column immediately following the 'Node Status' column. This new column should display the last date and time for the items in each specific row, essentially indicating the most recent status change of each node from 'UP' to 'DOWN' and vice versa.