Splunk Search

use eval variable in my search

gpSplunk123
Engager

hi, i'm trying to use an eval variable in my search. i've tried many different things and i've failed, and i'm sure this is a quick easy solution but i just can't seem to get it.  my eval variables print out exactly as i need, i have validated it with the table as well as manually put it in the search as well.

 

| eval z="legolas,TGZ,ux*"
| eval name="*" + mvindex(split(z, ","), 0) + "*"
| eval type=mvindex(split(z, ","), 1)
| eval query="*" + mvindex(split(z, ","), 2)
| eval searchVar=if(type="JAR", name, query)
| table name, type, query, searchVar
| search artifactory=* uri=searchVar
Labels (1)
0 Karma

richgalloway
SplunkTrust
SplunkTrust

The search command doesn't support field names on the right side of an expression.  Try where, instead.  Also, the table command stripped out the artifactory field so the search will never find a match.

| eval z="legolas,TGZ,ux*"
| eval name="*" + mvindex(split(z, ","), 0) + "*"
| eval type=mvindex(split(z, ","), 1)
| eval query="*" + mvindex(split(z, ","), 2)
| eval searchVar=if(type="JAR", name, query)
| where (match(artifactory, ".*") AND uri=searchVar)

 

---
If this reply helps you, Karma would be appreciated.
0 Karma

gpSplunk123
Engager

it didn't work for me, it still gave me 0 results found.  Replacing the search with the where clause.

0 Karma

richgalloway
SplunkTrust
SplunkTrust
Did you also remove the table command?
---
If this reply helps you, Karma would be appreciated.
0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

ATTENTION: We’re Moving! (AGAIN!)

The Splunk Community Slack is undergoing a system migration to keep our workspace secure and ...

Deep Dive: Optimizing Telemetry Pipelines in Splunk Observability Cloud

In this session, we will peel back the layers of Splunk Observability Cloud’s cost-optimization features. ...

Announcing Modern Navigation: A New Era of Splunk User Experience

We are excited to introduce the Modern Navigation feature in the Splunk Platform, available to both cloud and ...