This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Nodes by City - MODERN DASHBOARD

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.