Hi,
We would like to obtain the Node and Last 7 days Availability percentage data via the SolarWinds API.
Note we want the actual data and not to embed the SolarWinds widget in our user interface.
Please can you assist.
Regards,
Andrew
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
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.