All Apps and Add-ons

Splunk DB Connect: Why is my DB input config indexing partial data from the database?

muralianup
Communicator

I have a DB input (tail) set to run based on a SQL query. I ran a SQL "count" query which returned some numbers. Now, I ran the corresponding Splunk query and it's returning different results. So in short, it looks like the DB input is not indexing the whole output of the SQL query. Any ideas why this is happening? Is there any "maxevent" limit setting that's preventing the DB input to index the SQL query?

0 Karma

mreynov_splunk
Splunk Employee
Splunk Employee

you are not really giving enough information to troubleshoot. There is no maxevent setting.. look for errors in index=_internal, make sure the time range is the same and you are actually comparing apples with apples.

0 Karma
Get Updates on the Splunk Community!

[Puzzles] Solve, Learn, Repeat: Dynamic formatting from XML events

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...

Enter the Agentic Era with Splunk AI Assistant for SPL 1.4

  🚀 Your data just got a serious AI upgrade — are you ready? Say hello to the Agentic Era with the ...

Stronger Security with Federated Search for S3, GCP SQL & Australian Threat ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...