Using Custom properties field name as variable for Modern Dashboard SWQL query

Tsingh4

Hello Experts, I am trying to populate a custom table in in the modern dashboard to display total number of nodes and count by node types ( NW devices / Servers) which are already mapped to custom fields. .

Any suggestion with the proper variable calls will be of great help.

Below is the simple SWQL query I had tried as 2nd Value query to display total number of servers as an example:

select count(1) as countnodes
FROM orion.nodes
WHERE Orion.CustomProperties.NODES_TYPE​S = server

We are running Orion 2022.4.1 currently.

On a side notes, Curious how others are generally using Modern Dashboard for management only views

ecmel

In your SWQL query, you need to reference your Custom Property using link from Orion.Nodes object alias as shown below:

SELECT count(1) as countnodes

FROM Orion.Nodes N

WHERE N.CustomProperties.NODES_TYPE​S = 'server'