SWQL for all nodes monitored with following CustomProperties.CoreProductionSystem = 'YES'

jasonford1971

Trying to get a KPI widget to work for all nodes monitored but only for core systems (CustomProperties.CoreProductionSystem = 'YES') - how would i tag the swql onto the below 

SELECT Count(*) as TOTAL FROM Orion.Nodes

thanks 

kenyamson

try this

SELECT Count(*) as TOTAL FROM Orion.Nodes AS N INNER JOIN Orion.NodesCustomProperties AS CP ON CP.NodeID = N.NodeID WHERE CP.CoreProductionSystem = 'YES'