Splunk Search

How to use a lookup file to search for ip addresses in my logs?

jcaron9999a
Explorer

I have a lookup file called ipaddress.csv.  The column title in the file is ipaddress.  I want to search my logs for all of these ip addresses.  I know I need to use inputlookup to get the addresses from the file, but I can't figure out how to then feed them to a search.

 

Thanks in advance

Labels (2)
0 Karma
1 Solution

bowesmana
SplunkTrust
SplunkTrust

This is a subsearch, where the inputlookup is used as a subsearch

your_base_search [ | inputlookup ipaddress.csv | fields ipaddress ]

Here the subsearch ([] section) runs first and returns a structured piece of text with 

ipaddress=A OR ipaddress=B OR ipaddress=C

and so on to the outer search. Note that if your ip address field in your main index search is something different, then before the fields command, you should do a rename

| rename ipaddress as your_ip_field

 

View solution in original post

bowesmana
SplunkTrust
SplunkTrust

This is a subsearch, where the inputlookup is used as a subsearch

your_base_search [ | inputlookup ipaddress.csv | fields ipaddress ]

Here the subsearch ([] section) runs first and returns a structured piece of text with 

ipaddress=A OR ipaddress=B OR ipaddress=C

and so on to the outer search. Note that if your ip address field in your main index search is something different, then before the fields command, you should do a rename

| rename ipaddress as your_ip_field

 

jcaron9999a
Explorer

Thanks!  That did the trick.

0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...