How to sort "Down Interfaces" widget by most recent downtime?

quannm546

Hi everyone,

I am currently monitoring our system and need a dashboard widget that displays down interfaces. I found an existing "Down Interfaces" widget, but it currently sorts the list alphabetically by interface name.

I need the interfaces that went down most recently to appear at the top of the list. Is there an out-of-the-box widget for this, or is there a way to customize the sorting (e.g., using a custom SWQL/SQL query) to show the latest down interfaces first?

Thanks in advance for any help!

Lofstrand

Hi @quannm546

Try below SWQL query in a Custom Query Widget

SELECT TOP 10

    I.Node.Caption AS [Node]

    ,I.Caption AS [Interface]

    ,I.LastChange AS [Last Change]


    ,I.node.DetailsUrl AS [_LinkFor_Node]

    ,I.DetailsUrl AS [_LinkFor_Interface]

    ,CONCAT('/Orion/StatusIcon.ashx?entity=Orion.Nodes&id=',I.nodeid,'&status=',I.node.Status,'&size=Small') AS [_Iconfor_Node] 

    ,CONCAT('/Orion/StatusIcon.ashx?entity=Orion.NPM.Interfaces&id=',I.InterfaceID,'&status=',I.Status,'&size=Small') AS [_Iconfor_Interface] 

FROM Orion.NPM.Interfaces AS I

WHERE

    I.Status=2 --Down interfaces

ORDER BY

    I.LastChange DESC