Hi,
I am trying to map the ip address in my search to my lookup table, and it should return me the countries of the IP address.
Sample lookup table
country ip_address
Italy 2.123.123.9/24, 2.124.124.9/11
Problem is, in my events, my IP address is 2.123.123.1.
I want to search the ip_address in the lookup table perhaps for 2.123.123 and return me Italy ?
This is my search query
index=ip_address "status=200" ip_address
| lookup ip_mapping.csv ip_address outputnew u_country as country
The search executed successfully, but there is no country being returned. What am i missing ?
... View more