4 Replies Latest reply on Sep 21, 2018 2:21 PM by bharat9286

    SWQL CUSTOM QUERY TO SHOW INTERFACE PERCENT USAGE LIKE TOP 10 CHARTS with Search option

    bharat9286

      Hi All,

       

      I configured an SWQL query to show interface percent utilization, but i am unable configure custom search in that script, please help, below is the SWQL script.

       

      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],

      '/Orion/images/SubViewIcons/Routing.png' AS [_Iconfor_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 'wan1' OR

      i.InterfaceName LIKE 'port1' OR

      i.InterfaceName LIKE 'GigabitEthernet0/1'

      ORDER BY

      PercentUtil DESCENDING