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