williammy

Can this be ran within SWQL Studio? I'm getting an error that ao.EntityID isn't available

in SWQL Help – Report on Total Time Nodes Spent in Warning or Critical State (Last 30 Days) Comment by williammy June 2025

Hmm, The data between these two queries isn't quite lining up, For example, when I run the first query; SELECT n.Caption, n.IPAddress, n.CustomProperties.DeviceType, SUM(n.NodeDowntimeHistory.TotalDurationMin) AS TotalWarningOrDown, COUNT(n.NodeDowntimeHistory.TotalDurationMin) AS NumberOfWarningOrDown FROM Orion.Nodes n…

in SWQL Help – Report on Total Time Nodes Spent in Warning or Critical State (Last 30 Days) Comment by williammy May 2025

I don't have any specific requirements, I'm hoping to run a query against a specific nodem to get an alert of all alerts/status changes it had in the last 30 days. I'm primarily concerned about the name of the event (such as exceeded threshold critical memory usage) and the timestamp of the event.

in SWQL Help – Report on Total Time Nodes Spent in Warning or Critical State (Last 30 Days) Comment by williammy May 2025

Thank you, this seems to be promosing, I'm now trying to remember how to dig into the alert history for a specific node.

in SWQL Help – Report on Total Time Nodes Spent in Warning or Critical State (Last 30 Days) Comment by williammy May 2025

williammy ✭

Comments