All Apps and Add-ons

SPLUNK DB connect to database where table name is variable

Amirahussein
Path Finder

Dear SPLUNK users,

i have a question regarding SPLUNK DB Connect, as i want to access database (MySQL) where the table name is varied daily according to the timestamp.

So there a way to access these table through SPLUNK DB connect?

please advise

0 Karma

Azeemering
Builder

Did you try something like SELECT [table1].[column], [table1].[another-column], [table2].[column] FROM [table1], [table2]; in the input editor?
I’m having a bit of a hard time understanding what you mean with ‘variable table name based in timestamp’?

0 Karma
Get Updates on the Splunk Community!

Splunk Forwarders and Forced Time Based Load Balancing

Splunk customers use universal forwarders to collect and send data to Splunk. A universal forwarder can send ...

NEW! Log Views in Splunk Observability Dashboards Gives Context From a Single Page

Today, Splunk Observability releases log views, a new feature for users to add their logs data from Splunk Log ...

Last Chance to Submit Your Paper For BSides Splunk - Deadline is August 12th!

Hello everyone! Don't wait to submit - The deadline is August 12th! We have truly missed the community so ...