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 Availability last 7 days Report

SELECT R.Node.NodeID,R.Node.Caption, Nodes.IP_Address,AVG(R.Availability) AS Availability, NodesCustomProperties.SiteName,NodesCustomProperties.SiteID, NodesCustomProperties.SiteType,NodesCustomProperties.ISP,Nodes.Vendor,NodesCustomProperties.Capability,NodesCustomProperties.DeviceType
FROM Orion.ResponseTime R
INNER JOIN Orion.NodesCustomProperties ON NodesCustomProperties.NodeID = R.NodeID
INNER JOIN Orion.Nodes ON Nodes.NodeID = R.NodeID
WHERE ObservationTimestamp > ADDDAY(-7, GETUTCDATE())
GROUP BY R.Node.NodeID, R.Node.Caption,Nodes.IP_Address,NodesCustomProperties.SiteName,NodesCustomProperties.SiteID, NodesCustomProperties.SiteType,NodesCustomProperties.ISP,Nodes.Vendor,NodesCustomProperties.Capability,NodesCustomProperties.DeviceType

Find more posts tagged with

Accepted answers

All comments

Ramsundar

SELECT R.Node.NodeID,R.Node.Caption, Nodes.IP_Address,AVG(R.Availability) AS Availability, Nodes.Vendor
FROM Orion.ResponseTime R
INNER JOIN Orion.Nodes ON Nodes.NodeID = R.NodeID
WHERE ObservationTimestamp > ADDDAY(-7, GETUTCDATE())
GROUP BY R.Node.NodeID, R.Node.Caption,Nodes.IP_Address,Nodes.Vendor

LeBeauUK

There is a report in the Content Exchange created by @KMSigma.SWI

thwack.solarwinds.com/.../3003