Splunk Search

how to search for event matching lookup table

7ryota
Explorer

hi, i a total newbie

i need to do a search in splunk matching the domain in my lookup table (master_lookup.csv)

my table have the columns

indicators, published_date , last_update, labels

my index is below

((index=bcoat_logs AND sourcetype=bluecoat:proxysg:access:file ) OR (index=nanolog_906062_zscaler AND sourcetype=zscalernss-web))

how do i have the output when it match the indicators

my desired output will include
_time, indicators, published_date , last_update, labels

Labels (1)
0 Karma

7ryota
Explorer

indicators

 

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
((index=bcoat_logs AND sourcetype=bluecoat:proxysg:access:file ) OR (index=nanolog_906062_zscaler AND sourcetype=zscalernss-web))
| lookup master_lookup.csv indicators
| table _time, indicators, published_date , last_update, labels
0 Karma

7ryota
Explorer

the indicator is extract match?

connect.facebook.net is inside my csv file

will it be a able to search for facebook.net

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

It depends on your lookup definition - there are some advanced options available

ITWhisperer_0-1646211104242.png

 

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

What field or fields are you using from your index to lookup data in your lookup table?

0 Karma
Get Updates on the Splunk Community!

Splunk Mobile: Your Brand-New Home Screen

Meet Your New Mobile Hub  Hello Splunk Community!  Staying connected to your data—no matter where you are—is ...

Introducing Value Insights (Beta): Understand the Business Impact your organization ...

Real progress on your strategic priorities starts with knowing the business outcomes your teams are delivering ...

Enterprise Security (ES) Essentials 8.3 is Now GA — Smarter Detections, Faster ...

As of today, Enterprise Security (ES) Essentials 8.3 is now generally available, helping SOC teams simplify ...