Splunk Search

Filter search by subsearch values

ahcarpenter
Engager

Hi,

What's the best way to filter a search against a set of unique id's in a subsearch?


Currently, approaching it as such:

<events to filter against subsearch ids>
| join left subsearch_id 
| [search subsearch]

Though, it's returning a 1:1 set v. all primary search events that contain a matching id.

Labels (2)
0 Karma

richgalloway
SplunkTrust
SplunkTrust

There's no much to work with in the question, but perhaps this gives you an idea.

<events to filter against subsearch ids> [search subsearch | return 1000 subsearch_id]

The subsearch with return command returns a string of the type "(subsearch_id="foo" OR subsearch_id="bar")" which filters the events from the base search.

---
If this reply helps you, Karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

Shape the Future of Splunk: Join the Product Research Lab!

Join the Splunk Product Research Lab and connect with us in the Slack channel #product-research-lab to get ...

Auto-Injector for Everything Else: Making OpenTelemetry Truly Universal

You might have seen Splunk’s recent announcement about donating the OpenTelemetry Injector to the ...

[Puzzles] Solve, Learn, Repeat: Character substitutions with Regular Expressions

This challenge was first posted on Slack #puzzles channelFor BORE at .conf23, we had a puzzle question which ...