Splunk Enterprise

Search with lookup

bosseres
Contributor

Hello

I have a lookup, which contains hostnames, how can I make search over indexes (for example index=*) only by hostnames which in lookup? thank you.

Labels (1)
Tags (1)
0 Karma
1 Solution

scelikok
SplunkTrust
SplunkTrust

Hi @bosseres,

You can try below; I assume your lookup and indexed logs have "hostname" field. Otherwise you may need to rename fields.

index=* [|inputlookup hostname.csv | fields hostname]

 

If this reply helps you an upvote and "Accept as Solution" is appreciated.

View solution in original post

scelikok
SplunkTrust
SplunkTrust

Hi @bosseres,

You can try below; I assume your lookup and indexed logs have "hostname" field. Otherwise you may need to rename fields.

index=* [|inputlookup hostname.csv | fields hostname]

 

If this reply helps you an upvote and "Accept as Solution" is appreciated.

bosseres
Contributor

thank you!

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
index=* [| inputlookup hosts.csv | table host]
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Announcing Modern Navigation: A New Era of Splunk User Experience

We are excited to introduce the Modern Navigation feature in the Splunk Platform, available to both cloud and ...

Observability Simplified: Combining User Experience, Application Performance & ...

Tech Talk Observability Simplified: Combining User Experience, Application Performance & Network ...

Event Series May & June: From Network Visibility to Service Intelligence

Unifying the Network: Moving from Alert Noise to Service Intelligence with Splunk ITSI In today’s hybrid ...