All Apps and Add-ons

Splunk DB Connect Inserting Multiple Rows

kywolf
New Member

We have a DB Output setup to work off of the below search. The result from the search should be 1 row.

When the job runs (every 5 minutes) it inserts multiple rows into the external database table. It looks like it collects search result data as it's going through the indexed files and then inserts it all at once.

How can I limit this to only insert one row after the job has completely finished?

example search
index=network sourcetype=example "/uri/index*" earliest=-5m@m latest=now | stats count(eval(NOT request_status="blocked")) as Unblocked, count(eval(request_status="blocked")) as Blocked | head limit=1

example table

id  timestamp      unblocked  blocked
80  2015-07-01 11:30:15  89405    3
79  2015-07-01 11:30:15  88069   1
78  2015-07-01 11:30:15  65787   1
77  2015-07-01 11:30:15  22380   0

We should be getting the bold row only.

Tags (1)
0 Karma

jcoates_splunk
Splunk Employee
Splunk Employee

This sounds like it could be a bug, and is worth a support ticket. It is not expected to ignore your | head limit=1 statement.

0 Karma

jklumpp_splunk
Splunk Employee
Splunk Employee

Based on your question description it would appear to be a DB Connect question, but in looking at your search and your results that seems to be the odd part. Can you confirm that you used | head limit=1 and then received more than one result in the search?

0 Karma

kywolf
New Member

I agree, it is a DB Connect question. When I run that search in the Search & Reporting app, it returns 1 result. When I preview the result in the DB Output, it returns 1 line. When it runs on it's own, however, it inserts multiple rows.

Does anyone know of a DB Connect configuration option that could correct this?

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 ...