Proportional Widget filter option

anzar005

I am trying to create few site wise proportional widget.

but unable to create a filter so that i can get only the nodes from a particuilar site 

Using the following query, but this gives all nodes details 

I need only nodes from a specific site, is there any way i can add a filter to give me the node status for any node starting with XXX

SELECT COUNT(NodeID) as value, Status as status FROM Orion.Nodes GROUP BY status ORDER BY value DESC

KMSigma.SWI

How is site defined?  A Custom Property? The first 3 letters of a node name?  The IP Address?  That'll make all the difference.

SELECT COUNT([Nodes].NodeID) AS [NodesInStatus]
     , [Nodes].Status as [NodeStatus]
FROM Orion.Nodes AS [Nodes]
-- Possible WHERE Clauses for filters
-----------------------------------------------
---- Filter based on custom property called 'Site'
--WHERE [Nodes].CustomProperties.Site = 'SiteCode'
---- Filter based on IP matching a scheme
--WHERE [Nodes].IP LIKE '10.40.%.%'
---- Filter based on the first few characters in a node name
--WHERE [Nodes].Caption LIKE 'LOSA%'
GROUP BY [Nodes].Status
ORDER BY COUNT([Nodes].NodeID) DESC

I added aliases to all of the fields because it makes it easier to read (in my opinion).