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