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!

Leveraging Detections from the Splunk Threat Research Team & Cisco Talos

  Now On Demand  Stay ahead of today’s evolving threats with the combined power of the Splunk Threat Research ...

New in Splunk Observability Cloud: Automated Archiving for Unused Metrics

Automated Archival is a new capability within Metrics Management; which is a robust usage & cost optimization ...

Calling All Security Pros: Ready to Race Through Boston?

Hey Splunkers, .conf25 is heading to Boston and we’re kicking things off with something bold, competitive, and ...