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)
)
