1 Reply Latest reply: May 31, 2012 4:18 PM by Brice-Emmanuel Loiseaux RSS

    ADDM 8.3.2.2 split query result

    Marco .

      Hi,

      when I create a query in Generic Search Query, I can select tables and they relation with other table, but result column to join table is grouped.

      For example if I extract Host and their IP with

       

      SEARCH Host

      WHERE name has subword 'XXXXX'

      PROCESS WITH SHOW

      name AS HOSTNAME,

      host_type AS HOST_TYPE,

      local_fqdn AS LOCAL_FQDN,

      serial AS SERIAL_NUMBER,

      ram AS RAM,

      #DeviceWithInterface:DeviceInterface:InterfaceOfDevice:NetworkInterface.ip_addr AS IP_ADDRESS,))

       

      in column IP_ADDRESS I've a list of IP comma separated....

       

      AA | BB | CC | DD | 127.0.0.1, 127.0.0.2, 127.0.0.3

       

       

      Can I create a query that show me a record for any IP??

       

      AA | BB | CC | DD | 127.0.0.1

      AA | BB | CC | DD | 127.0.0.2

      AA | BB | CC | DD | 127.0.0.3

       

       

      TNK

      Marco

        • 1. Re: ADDM 8.3.2.2 split query result
          Brice-Emmanuel Loiseaux

          You can definitely do what you want if you use EXPLODE:

           

          SEARCH Host

          WHERE name has subword 'XXXXX'

          PROCESS WITH SHOW

          name AS HOSTNAME,

          host_type AS HOST_TYPE,

          local_fqdn AS LOCAL_FQDN,

          serial AS SERIAL_NUMBER,

          ram AS RAM,

          EXPLODE #DeviceWithInterface:DeviceInterface:InterfaceOfDevice:NetworkInterface.ip_addr AS IP_ADDRESS