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!

Why You Can't Miss .conf25: Unleashing the Power of Agentic AI with Splunk & Cisco

The Defining Technology Movement of Our Lifetime The advent of agentic AI is arguably the defining technology ...

Deep Dive into Federated Analytics: Unlocking the Full Power of Your Security Data

In today’s complex digital landscape, security teams face increasing pressure to protect sprawling data across ...

Your summer travels continue with new course releases

Summer in the Northern hemisphere is in full swing, and is often a time to travel and explore. If your summer ...