Filter the Proportional widget via custom property

Question

Hi, I am looking to filter the Proportional widget by custom property... I used the query provided in the SW "How to" for modern dashboards:

SELECT COUNT(1) AS Count_Items, Status 
FROM Orion.Nodes GROUP BY Status

Thanks

jm_sysadmin · Accepted Answer

Try this, replace Applicaitons to the name of your property, and '%SQL%' means match property string with SQL anywhere in it. The % is a match for any other set of characters, so if you don't need the wild cards, skip them. If you need 1, its still better.

SELECT COUNT(1) AS Count_Items, N.Status
FROM Orion.Nodes N 
Where N.CustomProperties.Applications like '%SQL%'

GROUP BY N.Status