2 Replies Latest reply on Oct 24, 2016 3:01 PM by johnny ringo

    Concat Orion Variable with string in SWQL?

    johnny ringo

      Hello,

      I am trying to automate naming my nodes in Orion using custom properties .  I think CASE in SWQL would be a simple way to do this but am having problems concatenating a string with a Orion variable.

       

        CASE

            WHEN  IPAddress LIKE '192.168.10.%' THEN ${City}

            WHEN  IPAddress LIKE '%.100' THEN ${City} + '-DC'

            WHEN  IPAddress LIKE '%.101' THEN ${City} + '-EXCH'    ELSE ${Caption} END AS N.Caption

       

      SWQL doesn't like using the plus sign.  Any sugestions?  Thanks for your help!