topic Re: How to pull out values from a lookup file based on user input without having to run any search commands or search through any logs? in Splunk Search

How to pull out values from a lookup file based on user input without having to run any search commands or search through any logs?

ryanprice22 — Tue, 29 Sep 2020 07:26:07 GMT

I have created a dashboard that allows for a user to input a public IP address and based on the input, pull back any data associated with that IP into various panels. On one of the panels I would like to pull out the values from a lookup file that I have created based on the user input without having to do any search commands or search through any logs.

Sudo code
$x.x.x.x$ = user input token

src_ip=$x.x.x.x$ | lookup ip_table IP as src_ip OUTPUT Company, Location

Re: How to pull out values from a lookup file based on user input without having to run any search commands or search through any logs?

walkerhound — Thu, 01 Oct 2015 21:40:21 GMT

I am not sure if this answers your question because it involves a search. Maybe you could use inputlookup.

|inputlookup ip_table |where IP=$x.x.x.x$|fields Company, Location

Re: How to pull out values from a lookup file based on user input without having to run any search commands or search through any logs?

ryanprice22 — Thu, 01 Oct 2015 23:05:13 GMT

Genius! It's so simple and that is exactly what I was looking didn't even think about using the where in the search. Thanks.

Re: How to pull out values from a lookup file based on user input without having to run any search commands or search through any logs?

ryanprice22 — Thu, 15 Oct 2015 05:21:34 GMT

Looking for more help on this. I came across this scenario when no results came back from the lookup table, but I still want to do something with the IP.

So basically if no results come back I still want to return the Geo information on the IP. If there are results then I want the results from the lookup and also return the Geo information.