Splunk Search

How do you store the matching value as a field?

szabados
Communicator

Suppose I have a query like:

index=my_index stringA OR stringB OR stringC | table logentry, whatmatched

And for the "whatmatched" field, I would like to have the particular string against my raw data has matched, yielding an output like:

logentry                          | whatmatched
this is message with stringB      | stringB
stringC comes here                | stringC

Is it possible to extract this somehow?

0 Karma

kmaron
Motivator

try this

| eval whatmatched = case(like(_raw, "%string1%"), "string1", like(_raw, "%string2%"), "string2", like(_raw, "%string3%"), "string3")
0 Karma
Get Updates on the Splunk Community!

Extending Observability Content to Splunk Cloud

Watch Now!   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to leverage ...

More Control Over Your Monitoring Costs with Archived Metrics!

What if there was a way you could keep all the metrics data you need while saving on storage costs?This is now ...

New in Observability Cloud - Explicit Bucket Histograms

Splunk introduces native support for histograms as a metric data type within Observability Cloud with Explicit ...