7 day memory run out capacity alert - SWQL

I am using the out of the box SWQL alert for memory run out and i've added a secondary section to the alert. I want it to alert for only the nodes that have the custom field set (MonkeyNutsAlerts) = Yes. I am still getting alerts for all servers in my environment not just the ones with the custom field set to 'Yes'. If anyone can tell me where I'm going wrong it would be much appreciated?

Have I just got the sections the wrong way round? Can I even do it like this?

Here is the alert so far...

Node Capacity Forecasting

SELECT NodesForecastCapacity.Uri, NodesForecastCapacity.DisplayName FROM Orion.NodesForecastCapacity AS NodesForecastCapacity

LEFT JOIN Orion.Nodes nodes on nodes.NodeID = NodesForecastCapacity.NodeID
LEFT JOIN Orion.Settings s ON s.SettingID = 'ForecastMinDays'

WHERE
NodesForecastCapacity.DaysToCapacityAvg <=7
AND NodesForecastCapacity.MetricName = 'Forecast.Metric.PercentMemoryUsed'
AND DayDiff(NodesForecastCapacity.MinDateTime, NodesForecastCapacity.MaxDateTime) >= ISNULL(s.CurrentValue, 7)
AND nodes.Unmanaged = false

Secondary Section :

Node

SELECT Nodes.Uri, Nodes.DisplayName FROM Orion.Nodes AS Nodes

WHERE Nodes.CustomProperties.MonkeyNutsAlerts LIKE 'Yes'

Find more posts tagged with

SWQL

capacity

Memory

Accepted answers

marcrobinson

Why two sections? This worked for me. I substituted your custom property for one of my one, and it worked just fine. I pasted my version below with your custom property. I use similar type of capacity alert for disk space.

SELECT NodesForecastCapacity.Uri
     , NodesForecastCapacity.DisplayName
FROM Orion.NodesForecastCapacity AS NodesForecastCapacity
LEFT JOIN Orion.Nodes nodes
     ON nodes.NodeID = NodesForecastCapacity.NodeID
LEFT JOIN Orion.Settings s
     ON s.SettingID = 'ForecastMinDays'
WHERE NodesForecastCapacity.DaysToCapacityAvg <= 7
     AND NodesForecastCapacity.MetricName = 'Forecast.Metric.PercentMemoryUsed'
     AND DayDiff(NodesForecastCapacity.MinDateTime, NodesForecastCapacity.MaxDateTime) >= ISNULL(s.CurrentValue, 7)
     AND nodes.Unmanaged = false
     AND Nodes.CustomProperties.MonkeyNutsAlerts = 'Yes'

All comments

marcrobinson

SELECT NodesForecastCapacity.Uri
     , NodesForecastCapacity.DisplayName
FROM Orion.NodesForecastCapacity AS NodesForecastCapacity
LEFT JOIN Orion.Nodes nodes
     ON nodes.NodeID = NodesForecastCapacity.NodeID
LEFT JOIN Orion.Settings s
     ON s.SettingID = 'ForecastMinDays'
WHERE NodesForecastCapacity.DaysToCapacityAvg <= 7
     AND NodesForecastCapacity.MetricName = 'Forecast.Metric.PercentMemoryUsed'
     AND DayDiff(NodesForecastCapacity.MinDateTime, NodesForecastCapacity.MaxDateTime) >= ISNULL(s.CurrentValue, 7)
     AND nodes.Unmanaged = false
     AND Nodes.CustomProperties.MonkeyNutsAlerts = 'Yes'

sum_giais

"MonkeyNutsAlerts"

Love the custom property name... and I'm hoping thats the real name in production

FormerMember

Of course... The military love my code names.

FormerMember

Thanks Marc. I'll try that in a bit and see if it works for me. I'm not sure why it didn't work all in one section.

FormerMember

Thanks Marc, this worked for me too. I am not sure why I decided to use two sections.