How does orion calculate availability? I have some monthly reports that pull average availability for last month and they run on the 1st of every month. one ran on the 1st of this month and showed a circuit only had 90.86% availability, when i looked at the switch log, i could not make the numbers add up. So i ran the report again today and got 87.00%. It is supposed to pull ony stats from M-F between the hours of 7 AM to 7 PM. Here is what the report looks like:
SELECT TOP 10000 CONVERT(DateTime,
LTRIM(MONTH(DateTime)) + '/01/' + LTRIM(YEAR(DateTime)),
101) AS SummaryMonth,
AVG(ResponseTime.Availability) AS AVERAGE_of_Availability,
Nodes.Branch AS Branch
FROM
Nodes INNER JOIN ResponseTime ON (Nodes.NodeID = ResponseTime.NodeID)
WHERE
( DateTime BETWEEN 39446 AND 39799 )
AND
(
(Nodes.State = 'LA') AND
(DATEPART(weekday, DateTime) <> 7) AND
(DATEPART(weekday, DateTime) <> 1) AND
(Convert(Char,DateTime,108) >= '07:00') AND
(Convert(Char,DateTime,108) <= '19:00')
)
GROUP BY CONVERT(DateTime, LTRIM(MONTH(DateTime)) + '/01/' + LTRIM(YEAR(DateTime)), 101),
Nodes.Branch
ORDER BY SummaryMonth ASC, 3 ASC
