Availability of Entire Network - Last Month Report SWQL Not Matching Web Report

Hello All,

I am attempting to create a SWQL or SQL query that will return the average availability of the entire network (All monitored nodes) for the last month. We currently have a web report that does this but would like to integrate this metric to a Power BI dashboard. However, when running SWQL or SQL against the database, the values returned do not match the web report values. Below is a screenshot of what the web report shows versus what the queries return, there are no filters on the web report. Any help or insight would be appreciated, the query was retrieved using the Hubble trace option.

Find more posts tagged with

network availability

Reporting

swql_query

Accepted answers

All comments

astayton

Did you ever get this working, I would love to copy your query.

sunvad

We use the following query for our availability KPI Widget - current month.

Select ROUND(AVG(orion_responseTime_availability_avg),2) as Net_Avail
from (
SELECT TOP 2000 aggSub._avg AS Orion_ResponseTime_Availability_avg
FROM Orion.Nodes n
LEFT JOIN ( select i.nodeid, avg(i.availability) as _Avg from orion.ResponseTime i
WHERE (MONTH(i.DateTime) <= Month((getdate())) and MONTH(i.DateTime) >= Month((getdate())))
AND NodeID IN (SELECT NodeID from Orion.NodesCustomProperties WHERE Owner = 'Network')
group by i.NodeID ) aggsub ON aggsub.nodeid=n.NodeID )

stuartd

Nice - we use something very similar except your CP owner we replace with client = ...