0 Replies Latest reply on Sep 3, 2009 8:14 AM by r0berth1

    Reports Do not work correctly!!!!!!!


      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

      Nodes INNER JOIN ResponseTime ON (Nodes.NodeID = ResponseTime.NodeID)

      ( DateTime BETWEEN 39446 AND 39799 )
        (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),

      ORDER BY SummaryMonth ASC, 3 ASC