This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

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 '<server name>')

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.