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.