SELECT
concat(round(avg(Availability), 2), ' %' ) as Network
FROM Orion.ResponseTime rt
where
monthdiff(datetime,getdate())=0 and rt.Node.CustomProperties.TETCO_Teams='Network'
To calculate node availability over a selected time period, the sum of all Response Time table records for the selected node over the selected time period is divided by the selected time period. This provides an average availability over the selected time period.
it is written below.
documentation.solarwinds.com/.../core-calculating-node-availability-sw1184.htm
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.