2 of 2 people found this helpful
The Nodes table isn't a time based table and the last response is only the last time that this node responded, so there is only one value in this table.
You need to find a table with DateTime column in, and as you are after response times, the interface tables may be a good place to start.
Try something iike:
SELECT n.Caption, AVG(rt.AvgResponseTime)
FROM Orion.ResponseTime rt
INNER JOIN Orion.Nodes n ON n.NodeID = rt.NodeID
WHERE n.Caption LIKE '%lalala%'
AND rt.DateTime > Addhour(-1, rt.DateTime)