Splunk Search

search using terms from lookup in an (mv) string field.

drodman29
Path Finder

I have an mvfield  of type string in my results. 

I want to search and match all values of this field for words that come from a csv lookup. 

LookupRows: 

{row1, "mary white"} 

{row2, "Tom White"} 

Results

Astring="Mary had a white lamb" , "tom had none" , "Joe was here" 

Astring="No match here" , "tom thumb" 

Searching with the lookup values against the full text of the event is not an acceptable answer. 

Labels (2)
0 Karma
1 Solution

drodman29
Path Finder

Resolved using a _raw rename. 

BaseSearch | eval MyRaw=_raw | mvexpand Astring | eval _raw=Astring | search [|inputlookup searchterms.csv] | table _time, Astring 

View solution in original post

0 Karma

drodman29
Path Finder

Resolved using a _raw rename. 

BaseSearch | eval MyRaw=_raw | mvexpand Astring | eval _raw=Astring | search [|inputlookup searchterms.csv] | table _time, Astring 

0 Karma
Get Updates on the Splunk Community!

The Splunk Success Framework: Your Guide to Successful Splunk Implementations

Splunk Lantern is a customer success center that provides advice from Splunk experts on valuable data ...

Splunk Training for All: Meet Aspiring Cybersecurity Analyst, Marc Alicea

Splunk Education believes in the value of training and certification in today’s rapidly-changing data-driven ...

Investigate Security and Threat Detection with VirusTotal and Splunk Integration

As security threats and their complexities surge, security analysts deal with increased challenges and ...