0 Replies Latest reply on Jul 9, 2010 5:20 AM by Jaja28

    Customize into per hour

    Jaja28

      SELECT  TOP 10000 DATEADD(hh, DATEDIFF(hh, GETUTCDATE(), GETDATE()) , CustomNodePollerStatistics_CustomPollerStatistics.DateTime) AS DateTime,
      Nodes.Caption AS NodeName,
      CustomNodePollers_CustomPollers.UniqueName AS Poller_Name,
      CustomNodePollerStatistics_CustomPollerStatistics."RowID" AS Row_ID,
      CustomNodePollerStatistics_CustomPollerStatistics.MinRate AS Minimum_Rate,
      CustomNodePollerStatistics_CustomPollerStatistics.AvgRate AS Average_Rate,
      CustomNodePollerStatistics_CustomPollerStatistics.MaxRate AS Maximum_Rate

      FROM
      ((Nodes INNER JOIN CustomPollerAssignment CustomNodePollerAssignment_CustomPollerAssignment ON (Nodes.NodeID = CustomNodePollerAssignment_CustomPollerAssignment.NodeID))  INNER JOIN CustomPollerStatistics CustomNodePollerStatistics_CustomPollerStatistics ON (CustomNodePollerAssignment_CustomPollerAssignment.CustomPollerAssignmentID = CustomNodePollerStatistics_CustomPollerStatistics.CustomPollerAssignmentID))  INNER JOIN CustomPollers CustomNodePollers_CustomPollers ON (CustomNodePollerAssignment_CustomPollerAssignment.CustomPollerID = CustomNodePollers_CustomPollers.CustomPollerID)


      WHERE
      ( DateTime BETWEEN 40365 AND 40366 )
       AND 
      (
        (CustomNodePollers_CustomPollers.UniqueName = 'cpmCPUTotal5minRev') AND
        (Nodes.Caption LIKE '%NAP%')
      )
      AND
      (
      (CustomNodePollerAssignment_CustomPollerAssignment.InterfaceID = 0)
      )