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!

Observe and Secure All Apps with Splunk

  Join Us for Our Next Tech Talk: Observe and Secure All Apps with SplunkAs organizations continue to innovate ...

Splunk Decoded: Business Transactions vs Business IQ

It’s the morning of Black Friday, and your e-commerce site is handling 10x normal traffic. Orders are flowing, ...

Fastest way to demo Observability

I’ve been having a lot of fun learning about Kubernetes and Observability. I set myself an interesting ...