SWQL query for KPI widget - Client custom properties

jprada

Hello,

I want to create some KPI widgets for the basic node information (count) (node down, node up, warning etc.). I have multiple Clients and I just want to specify to show me a client (all nodes, dropped nodes, uploaded nodes).

the code I'm using is to count all the nodes. however, I only want it to count the nodes of a single client. (All nodes, Nodes Down, Nodes Up)

these are my codes, I would like you to help me

All nodes:

select count(1) as countnodes from orion.nodes

Nodes Down:

select count(1) as countnodes from orion.nodes where status <>1

Nodes Up:

select count(1) as countnodes from orion.nodes where status =1

marlief22

Hi there, 

You mentioned in the title that you have a custom property for these customers but you haven't mentioned what this custom property is called so for my examples I'll just pretend it's a text custom property called 'Customer':

--All nodes:

select count(1) as countnodes from orion.nodes where Nodes.CustomProperties.Customer = 'CustomerName'

--Nodes Down:

select count(1) as countnodes from orion.nodes where status <>1 and Nodes.CustomProperties.Customer = 'CustomerName'

--Nodes Up:

select count(1) as countnodes from orion.nodes where status =1 and Nodes.CustomProperties.Customer = 'CustomerName'

If this helps answer your question please mark my answer as confirmed to help other users, thank you!

Marlie Fancourt | SolarWinds Pre-Sales Manager 

Prosperon Networks | SolarWinds Partner since 2006