This content has been marked as final. Show 2 replies
This Query should get you the last availability of all nodes in the last 7 days
SELECT R.Node.Caption, AVG(R.Availability) AS Availability FROM Orion.ResponseTime R WHERE ObservationTimestamp > ADDDAY(-7, GETUTCDATE()) GROUP BY R.Node.NodeID, R.Node.Caption ORDER BY Availability DESC
Thanks - that's pretty much what I was after!