All Apps and Add-ons

Can DB connect create an input with a dynamic database name

bestSplunker
Contributor

I have a application that produced a database with a current date everyday. (i.e today is 2019.12.20,then database name is DATA.20191220). I will to create a db input, the sql statement as follows:

select * from "DATA.20191220"."dbo"."PRINT_LOG"

If it's tomorrow, the sql statement should become as follows

    select * from "DATA.20191221"."dbo"."PRINT_LOG"

but I don't known how to connect a dynamic db name via DB connect App.

if u have a good idea,could u share it with me? thanks in advace.

forgive my English level, English is not my first language.

0 Karma

bestSplunker
Contributor

Can DB connect app solve this problem? Or do I have to use Python scripts to do this?

0 Karma
Get Updates on the Splunk Community!

Welcome to the Splunk Community!

(view in My Videos) We're so glad you're here! The Splunk Community is place to connect, learn, give back, and ...

Tech Talk | Elevating Digital Service Excellence: The Synergy of Splunk RUM & APM

Elevating Digital Service Excellence: The Synergy of Real User Monitoring and Application Performance ...

Adoption of RUM and APM at Splunk

    Unleash the power of Splunk Observability   Watch Now In this can't miss Tech Talk! The Splunk Growth ...