SWQL CPU average load (last 60mins) for just production nodes

jasonford1971

SWQL CPU average load for last hour for just production nodes

So i have the following swql for average cpu load last 60 mins, how would the swql look just for production nodes - with custom property n.CustomProperties.CoreProductionSystem - thanks 

SELECT TOP 10 n.Caption
,aggSub1._avg AS Orion_CPULoad_AvgLoad_avg
,n.DetailsUrl
,n.Status
,n.LastSync
FROM Orion.Nodes n
LEFT JOIN ( SELECT i.NodeID
,i.InstanceSiteId
, avg(i.AvgLoad) AS _avg
FROM Orion.CPULoad i
WHERE (i.DateTime > ADDHOUR (-1,GETDATE()))
GROUP BY i.NodeID,i.InstanceSiteId ) aggSub1 ON aggSub1.NodeID=n.NodeID AND aggSub1.InstanceSiteId=n.InstanceSiteId WHERE ($aggSub1._avg > 95)

TerryHarding

Hi Jason,

Add the Custom Property filter to the end where clause:

SELECT TOP 10 n.Caption
,aggSub1._avg AS Orion_CPULoad_AvgLoad_avg
,n.DetailsUrl
,n.Status
,n.LastSync
FROM Orion.Nodes n
LEFT JOIN ( SELECT i.NodeID
,i.InstanceSiteId
, avg(i.AvgLoad) AS _avg
FROM Orion.CPULoad i
WHERE (i.DateTime > ADDHOUR (-1,GETDATE()))
GROUP BY i.NodeID,i.InstanceSiteId ) aggSub1 ON aggSub1.NodeID=n.NodeID AND aggSub1.InstanceSiteId=n.InstanceSiteId

WHERE n.CustomProperties.CoreProductionSystem = 'YES' AND $aggSub1._avg > 95