I am trying to create a custom report to give me a list of sites with availability less than 95% in yesterday I have selected node name, IP address and availability under fields. The challenge comes when I try to filter fields specifying records that contain only records where availability is less than 95. The result however comes out showing a lot of sites that are not in this category and every site is listed with availability of 0.00%.
SELECT TOP 10000 Convert(DateTime,Floor(Cast((DateTime) as Float)),0) AS SummaryDate,
AVG(ResponseTime.Availability) AS AVERAGE_of_Availability
Nodes INNER JOIN ResponseTime ON (Nodes.NodeID = ResponseTime.NodeID)
( DateTime BETWEEN 42643 AND 42644 )
(Nodes.Branch_Type = 'My City') OR
(Nodes.Branch_Type = 'My State')
GROUP BY Convert(DateTime,Floor(Cast((DateTime) as Float)),0),
ORDER BY SummaryDate ASC, 6 ASC
Where Nodes custom property named “Branch_Type” fill with 'My City' and 'My State' are required nodes.
Shell be very thankful,