Can a modern dashboard have a better visual of 30/60/90 days availability? Below is the simple SWQL query where I just changed the '30' to a '60' and '90'. Anything helps.
--SWQL Query
SELECT COUNT(*) AS [100% Available]
FROM (
SELECT [Nodes].Caption
, AVG([Nodes].ResponseTimeHistory.Availability) AS [Availability]
FROM Orion.Nodes AS [Nodes]
WHERE [Nodes].Caption LIKE '%CHOA-AND%'
AND [Nodes].ResponseTimeHistory.DateTime BETWEEN GETDATE() - 30 AND GETDATE() -- this is where you define your time period
GROUP BY [Nodes].Caption
HAVING AVG([Nodes].ResponseTimeHistory.Availability) = 100
)
Top Comments