Splunk Search

How to search a query and a lookup file with common columns?

New Member

][1]

So, I would like to run my query below(which would return IP Addresses) and match the results to the input file by IP and return the DNS name?

Tags (2)
0 Karma
1 Solution

SplunkTrust
SplunkTrust

See https://docs.splunk.com/Documentation/Splunk/7.2.1/SearchReference/lookup - in your case something like some search here | lookup StaticDNS.csv IP OUTPUT Hostname

inputlookup is for loading the lookup's content as-is, not for enriching other events.

View solution in original post

0 Karma

Splunk Employee
Splunk Employee

hi @mmercola

Did the answer below solve your problem? If so, please resolve this post by approving it! If your problem is still not solved, keep us updated so that someone else can help ya. Thanks for posting!

0 Karma

SplunkTrust
SplunkTrust

See https://docs.splunk.com/Documentation/Splunk/7.2.1/SearchReference/lookup - in your case something like some search here | lookup StaticDNS.csv IP OUTPUT Hostname

inputlookup is for loading the lookup's content as-is, not for enriching other events.

View solution in original post

0 Karma

New Member

index="network" sourcetype=aerohive search [| inputlookup StaticDNS.csv

I'm stuck after this point

0 Karma