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!

Index This | I’m short for "configuration file.” What am I?

May 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with a Special ...

New Articles from Academic Learning Partners, Help Expand Lantern’s Use Case Library, ...

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

Your Guide to SPL2 at .conf24!

So, you’re headed to .conf24? You’re in for a good time. Las Vegas weather is just *chef’s kiss* beautiful in ...