topic Re: WILDCARD in lookup not working in Getting Data In

Why is WILDCARD in lookup not working?

Toki — Tue, 13 Sep 2022 12:51:39 GMT

I am using splunk cloud.
I would like to use the lookup file to find out if there is an IP corresponding to the blacklist, but only 10.50.88.22 is hit.

[definition of lookup]
WILDCARD (IP)

[Contents of lookupfile]
IP
10.50.88.22
10.30.50.70

[Search statement]
|makeresults format=csv data="IP
10.50.88.220
10.50.88.22
10.50.88.2"
|lookup test.csv IP OUTPUT IP as list_IP
|where list_IP IN(IP)
|table IP list_IP

If it works correctly, I want the following two to hit.
10.50.88.220
10.50.88.22

Referencing past questions and changing the lookup definition to the following did not work.
WILDCARD (IP)

Is my search statement wrong?
Any advice would be greatly appreciated.

Re: WILDCARD in lookup not working

bowesmana — Tue, 13 Sep 2022 02:04:19 GMT

Your lookup should contain an asterisk in the data where you want wildcard matching to work, e.g.

10.50.88.22*

but also you are using a lookup on the CSV itself, which does NOT support any wildcard lookup. You must use the definition name to perform the lookup, not the CSV file.

Re: WILDCARD in lookup not working

Toki — Tue, 13 Sep 2022 02:16:20 GMT

Thank you for your answer.
It is solved!