Hi,
I created a modified Availability for Entire Network report that was to focus on our main sites (CustomerName not equal to Remote). This report shows a 100% when I know some nodes were less than 100%. So I had about 1300 nodes at 100% but 66 were 66% - 99%. I am thinking that the average of all of these nodes should be less than 100%. Where am I thinking wrong here? SQL included below:
SELECT TOP 10000 AVG(ResponseTime.Availability) AS AVERAGE_of_Availability
FROM
Nodes INNER JOIN ResponseTime ON (Nodes.NodeID = ResponseTime.NodeID)
WHERE
( DateTime BETWEEN 40267 AND 40296.9999884259 )
AND
(
(Nodes.CustomerName <> 'Remote')
)
