Splunk Search

wildcard matching in lookup input

RSS_STT
Explorer

Can i do the wildcard matching in lookup?

|makeresults
|eval ip=192.168.101.10

|lookup ip.csv ip output host

In my lookup i have two entry ip=192.168.101.10 & ip=192.168.101.10/24.

How can i add wildcard (*) for match and i should get two entry.

 

Labels (1)
Tags (1)
0 Karma

jawahir007
Communicator

.

0 Karma

RSS_STT
Explorer

what if i want to match host_name= abc & host_name=abc_123 which is in lookup file.

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

The wildcard need to be defined in the lookup e.g. abc* will match abc and abc_123

0 Karma

RSS_STT
Explorer

could you please help with SPL syntax to match wild card entry.

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

If you have wildcards in your lookup, just use the lookup command

0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @RSS_STT ,

in the same option of the same section try with WILDCARD instead CIDR.

Ciao.

Giuseppe

0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @RSS_STT ,

in [Settings > Lookups > Lookup Definitions ] open "Advanced Options" and configure CIDR as match_type, as described at https://docs.splunk.com/Documentation/Splunk/9.4.0/Knowledge/Addfieldmatchingrulestoyourlookupconfig...

Ciao.

Giuseppe

0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.
Get Updates on the Splunk Community!

Tech Talk Recap | Mastering Threat Hunting

Mastering Threat HuntingDive into the world of threat hunting, exploring the key differences between ...

Observability for AI Applications: Troubleshooting Latency

If you’re working with proprietary company data, you’re probably going to have a locally hosted LLM or many ...

Splunk AI Assistant for SPL vs. ChatGPT: Which One is Better?

In the age of AI, every tool promises to make our lives easier. From summarizing content to writing code, ...