Widget Setup -KPI - Define group selections

CJR-HB

SELECT COUNT(1) AS KPI_Numbe from Orion.Groups WHERE Status= 2  

Hi All, 

Some ideas needed , the above SQL has been used to created a KPI widget to list DOWN nodes within the full Orion.Groups set. 

I need too be able to change the SQL to not list KPI data for all GROUPS but for specific only GROUPS . For example based on site location grouping. 

Could someone help to supply / edit / show an example of how to filter this , using the hand edit SQL options. 

thanks 

Cade 

m_roberts

Hi

For this you need to manipulate the WHERE clause, which is the construct in SQL (SWQL) to filter data is retrieved from the database. In your case you are asking to control which groups are retrieved. Therefore the following adjustment will allow this

SELECT COUNT(1) AS KPI_Numbe from Orion.Groups WHERE Status= 2  AND Name LIKE '%<group name>%'

Replace <group name> with the appropriate value. You may need more clauses, so the following resource will help you with additional complexity:

https://www.w3schools.com/sql/sql_where.asp

I hope this helps.