Use a SWQL custom query to show Interface Percent Usage like Top 10 charts

Question

Hi All,

I setup a quick SWQL Custom Query (below) to show certain Network Interfaces with the InPercentUtil and OutPercentUtil numbers, but I would rather display the numbers as they are shown in the Top 20 Interfaces by Percent Utilization (shown in snippet). Any help would be appreciated.

select

i.NodeID AS NODEID,

n.NodeName AS NODE,

i.Caption AS Interface,

i.InPercentUtil AS RECEIVE,

i.OutPercentUtil AS TRANSMIT

FROM

Orion.NPM.Interfaces as i

LEFT JOIN Orion.Nodes as n ON n.NodeID=i.NodeID

WHERE

(i.InterfaceIndex = 6 and i.InterfaceName LIKE 'Se%') OR

i.InterfaceName LIKE 'Ten-GigabitEthernet1/3/0/4[234]' OR

i.InterfaceName LIKE 'Bridge-Aggregation36' OR

i.InterfaceName LIKE 'Bridge-Aggregation6'

ORDER BY

n.NodeName, i.Caption

bharat9286 · Answer

Hey Vincesh, could you please add custom search SWQL query for given SWQL script.

vincesh · Answer

I did not find a solution to match the screenshot I provided, so I use the SWQL script below.

SELECT

n.NodeName AS Node,

n.DetailsUrl AS [_Linkfor_Node],

'/Orion/images/SubViewIcons/Network_02.png' AS [_Iconfor_Node],

i.InterfaceName AS Interface,

i.DetailsUrl AS [_Linkfor_Interface],

TOLOCAL(i.LastSync) AS LastCheck,

'/Orion/images/SubViewIcons/Routing.png' AS [_Iconfor_Interface],

i.InPercentUtil AS RECV,

CASE

WHEN i.InPercentUtil > 95 THEN '/Orion/images/StatusIcons/Small-Up-Critical.gif'

WHEN i.InPercentUtil > 89 THEN '/Orion/images/StatusIcons/Small-Up-Warn.gif'

ELSE '/Orion/images/StatusIcons/Small-Up.gif'

END AS [_Iconfor_RECV],

i.OutPercentUtil AS TRNS,

CASE

WHEN i.OutPercentUtil > 95 THEN '/Orion/images/StatusIcons/Small-Up-Critical.gif'

WHEN i.OutPercentUtil > 89 THEN '/Orion/images/StatusIcons/Small-Up-Warn.gif'