Splunk Search

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

mmercola
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

martin_mueller
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

mstjohn_splunk
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

martin_mueller
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.

0 Karma

mmercola
New Member

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

I'm stuck after this point

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 ...