0 Replies Latest reply on Apr 11, 2016 10:56 PM by ace003

    Custom Query - percentage bars


      Hi Twack,


      Support pointed me here as they don't seem to like anything involving customization . I'm trying to replicate the look of the "Top 10 Interfaces by Percent Utilization" resource, in my own custom query resource. This seemed like the best way to select a bunch of interfaces from different devices of my choosing. The problem I am having is i'm unable to work out how to display the percentages as colored bars.


      Top 10 resource:


      Custom resource:



      I assume there is some kind of [Percent_For_*] option, but it would appear to be undocumented and I've been unable to find anything on thwack.


      Here's my query in the interest of sharing:


      NODE.Caption AS NODE,

      INT.InterfaceCaption AS INTERFACE,

      INT.InPercentUtil AS RECEIVE,

      INT.OutPercentUtil AS TRANSMIT,

      '/Orion/images/StatusIcons/Small-' + INT.StatusIcon AS [_IconFor_INTERFACE],

      '/Orion/images/StatusIcons/Small-' + NODE.StatusIcon AS [_IconFor_NODE],

      INT.DetailsUrl AS [_LinkFor_INTERFACE],

      NODE.DetailsUrl AS [_LinkFor_NODE]

      FROM Orion.Nodes NODE

      LEFT OUTER JOIN Orion.NPM.Interfaces INT ON INT.NodeID = NODE.NodeID



      (NODE.NodeID = 123 AND INT.Name = 'GigabitEthernet1/0/23')


      (NODE.NodeID = 123 AND INT.Name = 'GigabitEthernet2/0/23')


      (NODE.NodeID = 1234 AND INT.Name = 'GigabitEthernet1/0/48')