Splunk Search

Splunk Join help

splunker9999
Path Finder

Hi, We are looking to join INDICATOR VALUE from lookup table to the search and needs to find out if a value is same.

Below is sample query I am currently doing:

 |inputlookup IOC.csv
|eval INDICATOR_VALUE=replace(INDICATOR_VALUE,"[\[\]]","")
|fields INDICATOR_VALUE
|join type=left INDICATOR_VALUE[search index=bank_nagw_preprod sourcetype=access_log clientip=*
|dedup clientip
|table clientip
|rename clientip as INDICATOR_VALUE
|fields INDICATOR_VALUE]

Thanks

Tags (1)
0 Karma

Raschko
Communicator

Doesn't the following search already delivers what you want?

search index=bank_nagw_preprod sourcetype=access_log
[ | inputlookup IOC.csv | eval INDICATOR_VALUE=replace(INDICATOR_VALUE,"[\[\]]","") |fields INDICATOR_VALUE | rename INDICATOR_VALUE AS clientip ]

Raschko
Communicator

Without using "join".

0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...