SWQL Network availability for last 24 hours for just production nodes

jasonford1971

So i have the following SQWL for Network availability for the last 24 hours 

select Round (AVG(orion_responseTime_availability_avg),2) as Net_Avail
from (
SELECT TOP 2000 aggSub._avg AS Orion_ResponseTime_Availability_avg
FROM Orion.Nodes n
LEFT JOIN ( select i.nodeid, avg(i.availability) as _Avg from orion.ResponseTime i
WHERE (i.DateTime > ADDDATE('day', -1, GETUTCDATE()))
group by i.NodeID ) aggsub ON aggsub.nodeid=n.NodeID )

but i need the SWQL just to pickup core productions systems ([Nodes].CustomProperties.CoreProductionSystem LIKE '%YES%'

How can i add this to the above SWQL - thanks 

TerryHarding

SELECT ROUND(AVG(orion_responseTime_availability_avg), 2) AS Net_Avail

FROM (

 SELECT TOP 2000 aggSub._Avg AS Orion_ResponseTime_Availability_avg, n.CustomProperties.CoreProductionSystem

 FROM Orion.Nodes n 

 LEFT JOIN (

 SELECT i.NodeID, AVG(i.Availability) AS _Avg FROM Orion.ResponseTime i

 WHERE (i.DateTime > ADDDATE('day', -1, GETUTCDATE()))

 GROUP BY i.NodeID ) aggSub ON aggSub.NodeID = n.NodeID

 WHERE n.CustomProperties.CoreProductionSystem LIKE 'YES'

 ) AS Sub