Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Node and Last 7 Days Availability Data

whitwa

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

Find more posts tagged with

node last 7 days availability data

Accepted answers

All comments

derhally

This Query should get you the last availability of all nodes in the last 7 days

SELECT R.Node.Caption, AVG(R.Availability) AS AvailabilityFROM Orion.ResponseTime RWHERE ObservationTimestamp > ADDDAY(-7, GETUTCDATE())GROUP BY R.Node.NodeID, R.Node.CaptionORDER BY Availability DESC

whitwa

Thanks - that's pretty much what I was after!