All Apps and Add-ons

Splunk DB 3 connect fetching the last DB record repeatedly


I am connecting to MS SQL server to fetch records into Splunk using Rising column. The rising column is a datetime column. When the execution runs then SplunkDBConnect pulls all available records, so first time it runs as expected. From the second poll it starts getting the last record again and hence leading to data duplication in Splunk environment.
My query is SELECT * FROM WHERE StartTime > ? ORDER BY StartTime ASC.
The coulmn StartTime has datetime datatype.

I also see updates going to checkpoint file. I currently poll every 60 seconds.

Has anyone seen such a behavior?


0 Karma
Get Updates on the Splunk Community!

Observability | How to Think About Instrumentation Overhead (White Paper)

Novice observability practitioners are often overly obsessed with performance. They might approach ...

Cloud Platform | Get Resiliency in the Cloud Event (Register Now!)

IDC Report: Enterprises Gain Higher Efficiency and Resiliency With Migration to Cloud  Today many enterprises ...

The Great Resilience Quest: 10th Leaderboard Update

The tenth leaderboard update (11.23-12.05) for The Great Resilience Quest is out >> As our brave ...