I'm a beginner with SWQL, so this could be a very simple question... I have created a SWQL script to create a widget that displays nmetwork nodes that are currently down. How can I add a column displaying what date they went at?
SELECT [Nodes].Caption
, [Nodes].IPAddress
, [Nodes].DetailsURL AS [_LinkFor_Caption]
, [Nodes].DetailsURL AS [_LinkFor_IPAddress]
, '/Orion/images/StatusIcons/Small-Down.gif' AS [_IconFor_Caption]
FROM Orion.Nodes as [Nodes]
WHERE [Nodes].Category = '1'
AND Status = 2 -- Status of 2 signifies 'down'
ORDER BY Caption
Also, how often do widgets update their content?
Thanks
