Splunk Search

How to search for a field value with a wildcard and a variable?

asamajdwar
New Member
index="test_index"
|table Calendar, Job, Status
|eval dayNow=strftime(now(),"%A")
|search Calendar= ???

My 'Calendar' field value is like 'Monday,Wednesday,Saturday'. So if current day(dayNow variable) is say Wednesday, I should get list of jobs for the day. I am trying to use wildcard with the dayNow variable. Something like Calendar = "%dayNow%".
I am not able to find anything to achieve this so far.

0 Karma

DalJeanis
SplunkTrust
SplunkTrust

Try this...

 index="test_index"
 | table Calendar, Job, Status
 | eval dayNow=strftime(now(),"%A")
 | makemv delim="," Calendar
 | mvexpand Calendar
 | where Calendar=dayNow

What the above does is, use the commas to break the Calendar field up into a multivalue field, then use mvexpand to make each record into one record per day that it is supposed to run. After that, we filter to eliminate any records that do not match today's day.

.conf21 Now Fully Virtual!
Register for FREE Today!

We've made .conf21 totally virtual and totally FREE! Our completely online experience will run from 10/19 through 10/20 with some additional events, too!