All Apps and Add-ons

Splunk DB Connect 2 Database Output earliest and latest

peter_krammer
Communicator

Hi!

I created a database output with Splunk DB Connect 2, but the app outputted too much data to the DB and it took a long time.
I figured out that the earliest and latest values from the saved search were not used by the db_output script.
So I switched to a non saved search (inline search) in the db output, because there you can select it from the timepicker.
But even than the db output used all time again...
So I looked into the inputs.conf of the app (because it stores its outputs there -.- ) and found out there are no values saved for earliest and latest. Even in the specs in the documentation there is no reference for such values.

How am I supposed to limit my db output to a specific timespan? (eg.: -1d@d to now)

0 Karma

peter_krammer
Communicator

I was able to use the following workaround for the time being.
You can select earliest and latest values in the SPL.
index=test earliest="-1d@d" latest="@d" | ...

But if anybody has a real solution to this I would appreciate it.

0 Karma
Get Updates on the Splunk Community!

Fall Into Learning with New Splunk Education Courses

Every month, Splunk Education releases new courses to help you branch out, strengthen your data science roots, ...

Super Optimize your Splunk Stats Searches: Unlocking the Power of tstats, TERM, and ...

By Martin Hettervik, Senior Consultant and Team Leader at Accelerate at Iver, Splunk MVPThe stats command is ...

How Splunk Observability Cloud Prevented a Major Payment Crisis in Minutes

Your bank's payment processing system is humming along during a busy afternoon, handling millions in hourly ...