i have one trouble, i went to extract IP address that not in Lookup of list servers and not in lookup of list network devices, and this IP must match with list of Subnet define in lookup. the gol of this request it's to find unknown IP address.
this is structure of lookup CSV
for exemple if on my index i find IP like 10.18.18.36 that IP is not on server.csv and network.csv but match with subnet 10.18.0.0/16 i went to send ALERT but if this IP exist on lookup server or network isn't a problem.
this is my request :
|rename dns_ip as IP_addresses
|search [| inputlookup subnet.csv | fields Plage| rename Plage as IP_addresses]
[|inputlookup server.csv|fields IP_addresses]
[|inputlookup Network.csv | fields IP_addresses]
| table IP_addresses
But this request give me all IP on lookup network and lookup server and match with lookup subnet, please any one can help me?
... View more