Splunk Search

When I run a search by itself, it works fine, but when I run it as a subsearch, why is the resulting table empty?

mcgi906
Explorer
index=a | eval SPLITid=[search index=b | eval tempid= substr(SPLITLOTID,2,8) | return $tempid ] | table SPLITid

When I run the search by itself, it works fine, but when I run it as a subsearch the table is empty. Any ideas as to why?

0 Karma

mohebtalukder
New Member

Below search works:

index=_* | eval SPLITid=[search index=_audit | eval tempid=substr(id,2,5) | return $tempid] | table SPLITid

But next one did not work for me when I changed the field name:

index=_* | eval SPLITid=[search index=_audit | eval tempid=substr(source,2,5) | return $tempid] | table SPLITid

So, I will suggest you to lookinto substr command. Put it in between " " like below:

"substr(source,2,3)"

Working search:

index=_* | eval SPLITid=[ search index=_audit | eval tempid="substr(source,2,3)" | return $tempid] | table SPLITid

I hope you will find it helpful!!

0 Karma

somesoni2
Revered Legend

Give this a try

index=a | eval SPLITid=[search index=b | eval search= "\"".substr(SPLITLOTID,2,8)."\"" | return search ] | table SPLITid
0 Karma
Get Updates on the Splunk Community!

Introducing the Splunk Community Dashboard Challenge!

Welcome to Splunk Community Dashboard Challenge! This is your chance to showcase your skills in creating ...

Built-in Service Level Objectives Management to Bridge the Gap Between Service & ...

Wednesday, May 29, 2024  |  11AM PST / 2PM ESTRegister now and join us to learn more about how you can ...

Get Your Exclusive Splunk Certified Cybersecurity Defense Engineer Certification at ...

We’re excited to announce a new Splunk certification exam being released at .conf24! If you’re headed to Vegas ...