1 Reply Latest reply on Feb 5, 2014 2:56 AM by Jan Pelousek

    Custom SWQL resource

    stuartwhyte

      Hello,

       

      The following SWQL code:

       

      SELECT
      n.caption as Node,
      '/Orion/images/StatusIcons/Small-' + n.StatusLED AS [_IconFor_Node],
      n.ipaddress as IP_Address,
      n.ObjectSubType as Polling_Method,
      n.StatusDescription as Status,
      '/Orion/images/StatusIcons/Small-' + i.StatusLED AS [_IconFor_Interface],
      I.Caption as Interface
      
      FROM Orion.NPM.Interfaces I
      left join orion.nodes n on n.nodeid=I.nodeid
      
      

       

      produces

       

      before.JPG

       

      Can I make it look like:

       

      after.JPG

       

      I've tried grouping by node name, but cant seem to make it work.

       

      As a value add, I'd like to have volumes added under the interfaces for nodes that have them.

       

      Thanks

       

      Stuart