Splunk Search

Subquery Does Not Return Any Result

pramit46
Contributor

I have two different sourcetypes: S1 and S2 (under different indexes)

I want to print, three extracted custom fields from those two sourcetypes: F1 & F2 (belong to S1) and F3 (belongs to S2). I used the following query:

sourcetype= S1 or sourcetype= S2 | fields F1, F2, F3

It shows "No results found."

Basically, my motive is to print the values of certain fields from these two sourcetypes including F1, F2 & F3.

When I use: sourcetype= S1 | fields F1, F2 it comes up nice.

F1, F2, F3 can be multivalued fields which may or may not contain same values.

Any suggestions?

0 Karma
1 Solution

MuS
SplunkTrust
SplunkTrust

Hi pramit46,

Your search brings no result, because you will not have any events containing all three fields. You only have either F1 and F2 or F3.

But to get all three fields try something like this:

 sourcetype=S1 OR sourcetype=S2 | stats values(F1) AS F1, values(F2) AS F2, values(F3) AS F3 

hope this helps ...

cheers, MuS

View solution in original post

MuS
SplunkTrust
SplunkTrust

Hi pramit46,

Your search brings no result, because you will not have any events containing all three fields. You only have either F1 and F2 or F3.

But to get all three fields try something like this:

 sourcetype=S1 OR sourcetype=S2 | stats values(F1) AS F1, values(F2) AS F2, values(F3) AS F3 

hope this helps ...

cheers, MuS

pramit46
Contributor

Thanks @MuS,
I tried that, too.. But did not get much luck. then I realized that I had to use the or as OR and it worked.

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!

Accelerate Splunk App Development with AI

  Learn how to automate the repetitive parts of your build cycle.   Watch On-Demand   Replay the Accelerate ...

Splunk Agent Observability: Measuring AI Value with Splunk Tokenomics on AWS

The AI landscape is moving faster than ever, and our latest 2026 State of Observability report provides the ...

Enterprise Security Watch Party: What’s New in 8.8 - Recap

Splunk Community HQ hosted a Splunk Enterprise Security Watch Party: What’s New In ES 8.8 last Thursday. I had ...