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