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!

njoylif

try the CONCAT(${City},'-DC')

and get rid of the $  in the AS statement...