Query nodes failing to poll via their configured polling technology

This query is more meant to be an alert, however could also be thrown into a custom widget within a view and is very useful to have in and of itself also.

SELECT Nodes.Uri, Nodes.DisplayName
FROM Orion.Nodes AS Nodes
WHERE ( MINUTEDIFF(Nodes.LastSystemUptimePollUtc, GETUTCDATE()) >= 480
AND ( Nodes.PolledStatus = 1 AND Nodes.ObjectSubType IN ('Wmi', 'Agent', 'SNMP') ) )

Anonymous