Hello all, Hoping someone may be able to help. I have an internal tool I have an export from in the from of a CSV that has a column named ip. I uploaded this as a inputlookup (name.csv). I verifed I can see the ip information by |inputlookup (name.csv) and the rows of IP addresses show.
I have a base search that returns data , and I want to see if any of the src, or dest IP's from my search match the IP addresses listed in my name.csv. I keep running into a search, that returns a few thousand events, although I can search the event between src, and dest and it shows without the lookup.
Currently my search looks like this:
(index=name1 OR index=name2 OR index=name3) src_ip_country=United States action=allowed
| stats count by src, dest
| sort count
| reverse
| lookup name.csv ip OUTPUT target_ip
| table target_ip, src, dest
This search provides me a tabled output with src, and dest fields populated, but nothing in the "target_ip" field. Any ideas? Thank you.
... View more