Need SWQL for custom poller data that is more than 4 hours old

patriot

I have the following query, but I would like to limit the output to nodes that have a custom poller timestamp that is more than 4 hours old. Can anyone help with that part? I appreciate it.

SELECT TOP 1000 NodeID, ObjectSubType, IPAddress, IPAddressType, DynamicIP, Caption, NodeDescription, Description, DNS, Status, PolledStatus, StatusLED, StatusDescription, CustomPollerLastStatisticsPoll, CustomPollerLastStatisticsPollSuccess FROM Orion.Nodes

weston.hood

Maybe something like this? Looks like nodes w/o any assignment are automatically given a timestamp of 1899-12-30 06:00:00 so I have also eliminated those entries (assuming you want that).

SELECT TOP 1000 NodeID, ObjectSubType, IPAddress, IPAddressType, DynamicIP, Caption, NodeDescription, Description, DNS, Status, PolledStatus, StatusLED, StatusDescription, CustomPollerLastStatisticsPoll, CustomPollerLastStatisticsPollSuccess  FROM Orion.Nodes
WHERE CustomPollerLastStatisticsPoll < ADDDATE('HOUR', -4, GETDATE()) and CustomPollerLastStatisticsPoll != '1899-12-30 06:00:00'