SWQL query for KPI widget - node custom properties

Question

Hello,

I want to create some KPI widgets for the basic node information (count) (node down, node up, warning etc.). I cannot figure out how to filter these results by the custom node properties - example: One widget to count how many nodes are down from a specific region(from node custom properties) (Europe for example).

I have this query that returns the value of all nodes present, I've tried to apply some conditions to it but no success:

select count(1) as countnodes from orion.nodes

All the help will be appreciated.

Thank you.

stuartd · Accepted Answer

I've just completed a very similar exercise for a modern dashboard.

The code I have used is as follows:

SELECT COUNT(1) AS KPI_Numbe 
from Orion.Nodes AS a
JOIN Orion.NodesCustomProperties as b ON a.NodeID = b.NodeID
WHERE Status = '2' AND ClientPrefix LIKE '%Insert_Text_Here%'

So, for our setup, we have a custom property called 'ClientPrefix' and in the "Insert_Text_Here" but I have just put in the appropriate prefix we need. So using your example that line for you, would be something like:

* WHERE Status = '2' AND CP_Name LIKE '%Europe%'

Obviously you'd need to adjust the custom property name to suit.

For each section you need, just adjust the status code as required.

Status

2 = down
3 = warning
9 = unmanaged

HTH?