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

Uptime widget on dashboard showing different results than Node Details page

Hi All,

I have added a widget on one of my modern dashboards to show uptime for the last 30 days but the value I am getting is different than the "Availability Statistics" on the Node Details page. Here is my SWQL query:

SELECT TOP 10 n.NodeName,aggSub1._avg AS Orion_ResponseTime_Availability_avg 
FROM Orion.Nodes n 
LEFT JOIN ( 
  SELECT i.NodeID,i.InstanceSiteId 
  , avg(i.Availability) AS _avg  FROM Orion.ResponseTime i
  WHERE ( DateTime > (GetDate()-30) )
GROUP BY i.NodeID,i.InstanceSiteId
) aggSub1 ON aggSub1.NodeID=n.NodeID AND aggSub1.InstanceSiteId=n.InstanceSiteId 
WHERE (NodeName LIKE '')

This returns a value of 99.999 but Node Details page says uptime is 99.977 % for the last 30 days. Can someone help me understand this discrepancy? Is there something wrong with my SWQL query?

Thanks in advance.

Find more posts tagged with

dashboard

SWQL

uptime

Accepted answers

All comments

adam.beedell

If you change GetDate() to GetUTCDate() does that clear the discrepancy?

koneal

Not quite. I do get a different result but it still does not match the Node Details page.

GetDate() - 99.99894834258792
GetUTCDate() - 99.99894727977093

monitoringlife

Was thinking the same thing, or they are loading the time ranges differently (might not be doing 30 days, but calendar function for days in this month (ex: Feb only has 28 days)).