I am trying to create a KPI Widget that will do a count for All Nodes but using a specific customproperties and also nodes that are UP using a specific custom property
I have edited the City customproperties of the required nodes to "RochesterR" below is an SWQL query I am trying to build
SELECT count(1) as KPI_Numbe from orion.nodes
WHERE status=1
AND (N.customproperties.City like 'RochesterR')
I am getting an error, Kindly assist.