topic Re: Can we pass main search result value into subsearch as search command? in Splunk Search

Can we pass main search result value into subsearch as search command?

avadhutha — Thu, 22 Dec 2022 15:42:38 GMT

mainsearch| stats count(_raw) as Cou by hour
|join hour [ subsearch| head -$Cou$ ]

Above mentioned command is not working, as main search values can be used as values in subsearch but unable to use it under a command. Any suggestions?

Re: Can we pass main search result value into subsearch as search command?

yuanliu — Fri, 23 Dec 2022 06:59:12 GMT

The question is not whether you can pass main search result value into subsearch, but what is it you are trying to perform. There are many ways to implement anything in any general-purpose language such as SPL. You already know the method proposed in the OP doesn't do what you wanted. So, start by explaining your data, your logic, and your expected output. (This should be the general formula when posing a question.)

Starting from data and logic is even more important because join command is often the least efficient way to achieve anything. Most of the time, join can be avoided.

Re: Can we pass main search result value into subsearch as search command?

avadhutha — Fri, 23 Dec 2022 08:14:41 GMT

Thank you @yuanliu for feedback. I have created a new conversation based on your suggestions.

https://community.splunk.com/t5/Splunk-Search/how-to-get-90-of-max-execution-time/m-p/625167#M217321