Deployment Architecture

Using foreach and dbquery, why am I getting error "'foreach' command: Search pipeline may not contain non-streaming commands"?

sebdemarss
Engager

Hi everybody

This error is causing me problems.
From a result set (a table with a "name" field) I want to run this type of request:

<query>foreach name [|dbquery "maBase" "SELECT summary,id FROM maBase.maTable"| search summary=*name*]</query>

This means that for each line, searching a database (dbquery) and I return results based on the presence of the name in the "summary" of my base.

however, I found an error:
'foreach' command: Search pipeline may not contain non-streaming commands

if someone has an idea
thank you all

Sébastien

0 Karma

jcoates_splunk
Splunk Employee
Splunk Employee

dbquery has to be the first command in a search. You could do your filtering after that though, something like this: https://answers.splunk.com/answers/75999/splunk-db-connect-dbquery-inline-search-and-time-filtering-...

0 Karma
Get Updates on the Splunk Community!

Prove Your Splunk Prowess at .conf25—No Prereqs Required!

Your Next Big Security Credential: No Prerequisites Needed We know you’ve got the skills, and now, earning the ...

Splunk Observability Cloud's AI Assistant in Action Series: Observability as Code

This is the sixth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how to ...

Splunk Answers Content Calendar, July Edition I

Hello Community! Welcome to another month of Community Content Calendar series! For the month of July, we will ...