0 Replies Latest reply on Jun 28, 2018 12:58 PM by athlon2k2

    Alerts > Execute an NCM Action

    athlon2k2

      I'm trying to get an IP address of a specific interface and then run some commands from another device. I am using SWQL to get the IP address and a SWIS variable to pass the NodeID.

       

      Does anyone know if there is a limitation for resolving variables and SWQL at the same time?

       

      Here is what I'm trying to do.

       

      ping ${N=SWQL;M=select IPAddress from Orion.NodeIPAddresses where IPAddress like '10.254.%' and InterfaceIndex = '2' and NodeID = '${N=SwisEntity;M=NodeID}'}

       

      Here is the result.

       

      ping ${N=SWQL;M=select IPAddress from Orion.NodeIPAddresses where IPAddress like '10.254.%' and InterfaceIndex = '2' and NodeID = '32'}
      ^
      % Invalid input detected at '^' marker.

       

      You can see that the variable resolves but the SWQL doesn't, but if I run just SWQL like below it works (I expect the pings to fail).

       

      ping ${N=SWQL;M=select IPAddress from Orion.NodeIPAddresses where IPAddress like '10.254.%' and InterfaceIndex = '2' and NodeID = '32'}

       

      ping 10.254.x.x
      Type escape sequence to abort.
      Sending 5, 100-byte ICMP Echos to 10.254.x.x, timeout is 2 seconds:
      .....
      Success rate is 0 percent (0/5)