Im trying to customize my down interface panel im using from the public Network Summary - Network Summary dashboard to order by last changed. But I cant seem to find out how to do this. Im tried looking into SWQL commands to add to the "Filter nodes (SWQL)" portion but cant figure out if I can do it there with my basic SQL knowledge. Is there a place where I can customize this panel to order that way?
Can I organize my Network Summary - Network Summary default dashboard to show the Down Interfaces panel chronologically?
-
Below is a start if you want to create your own. Add this SWQL as Custom Query widget.
SELECT NodeName AS [Node Name], '/Orion/images/StatusIcons/Small-' + StatusIcon AS [_IconFor_Node Name], DetailsUrl AS [_LinkFor_Node Name], --MAX(DOWNEVENT.EVENTTIME) AS [DOWN TIME] MAX(tolocal(DOWNEVENT.EVENTTIME)) AS [DOWN TIME] FROM ORION.NODES NODES INNER JOIN ORION.EVENTS DOWNEVENT ON NODES.NODEID = DOWNEVENT.NETWORKNODE WHERE STATUS = 2 GROUP BY NodeName, StatusIcon, DetailsUrl ORDER BY [DOWN TIME] DESC