Custom Widget

Hi, I need to create a widget that displays the total number of Nodes based on a custom Property. How can I achieve this through an SWQL Query?

Find more posts tagged with

swql query

node by type

npm

custom_report

I would use something like this:

SELECT Count(N.NodeID) as [Total Devices]
FROM Orion.Nodes N
where N.CustomProperties.Support_Group like '%Value%'

In the example, 'Support_group' is the name of the custom property and its looking nodes with a string that contains 'Value'

If you have issues, give me the name of the property and the value(s) that you care about, and maybe describe what you hope to see in which widget.

I would use something like this:

SELECT Count(N.NodeID) as [Total Devices]
FROM Orion.Nodes N
where N.CustomProperties.Support_Group like '%Value%'

In the example, 'Support_group' is the name of the custom property and its looking nodes with a string that contains 'Value'

If you have issues, give me the name of the property and the value(s) that you care about, and maybe describe what you hope to see in which widget.

Thanks for sharing this