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!

Fastest way to demo Observability

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

September Community Champions: A Shoutout to Our Contributors!

As we close the books on another fantastic month, we want to take a moment to celebrate the people who are the ...

Splunk Decoded: Service Maps vs Service Analyzer Tree View vs Flow Maps

It’s Monday morning, and your phone is buzzing with alert escalations – your customer-facing portal is running ...