Splunk Enterprise Security

using lookup values as input to variable

vishaltv
Path Finder

Splunk search query :

index="something" | search hostname=variable

  • using lookup file, map the variable value

Please help.

Thanks in advance

0 Karma

woodcock
Esteemed Legend

With a subsearch, like this:

index="something" AND [|inputlookup YourLookupNameHere.csv | table hostname | format]

aberkow
Builder

Are you asking for how to reference a csv based on a variable value? There is a lookup command https://docs.splunk.com/Documentation/Splunk/7.3.2/SearchReference/Lookup#Basic_example that you can use - in this case the syntax would look something like:

base search...
| lookup csvName.csv variable OUTPUT fieldsToOutput

In this case variable is the joining field between the csv and the base search, and you can OUTPUT whatever fields you want from that row (comma separated list).

Does this answer your question?

0 Karma
Get Updates on the Splunk Community!

Bridging the Gap: Splunk Helps Students Move from Classroom to Career

The Splunk Community is a powerful network of users, educators, and organizations working together to tackle ...

Preparing your Splunk Environment for OpenSSL3

The Splunk platform will transition to OpenSSL version 3 in a future release. Actions are required to prepare ...

Unleash Unified Security and Observability with Splunk Cloud Platform

     Now Available on Microsoft AzureThursday, March 27, 2025  |  11AM PST / 2PM EST | Register NowStep boldly ...