All Apps and Add-ons

Is there a log file that shows the SQL statements DB Connect Database Inputs are generating?

steverimar
Explorer

Hi

I am trying to debug a database input I created to pull from a JDBC compliant DB. I set it up as a Tail so it pulls records incrementally. I need to see the SQL statements that this input is generated automatically. Is there a log file of some sort that captures the SQL statements? I tried looking in the _internal index and nothing is coming up. Thanks!

0 Karma

jerniganbrandon
Explorer

Have you taken a look at: http://docs.splunk.com/Documentation/DBX/2.1.0/DeployDBX/Troubleshooting#What_DB_Connect_logs

Looks like it should be enabled by default, but you'll want to verify dbx_logging.conf

jcoates_splunk
Splunk Employee
Splunk Employee

that's just was I was going to say 🙂

0 Karma
Get Updates on the Splunk Community!

Announcing Scheduled Export GA for Dashboard Studio

We're excited to announce the general availability of Scheduled Export for Dashboard Studio. Starting in ...

Extending Observability Content to Splunk Cloud

Watch Now!   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to leverage ...

More Control Over Your Monitoring Costs with Archived Metrics GA in US-AWS!

What if there was a way you could keep all the metrics data you need while saving on storage costs?This is now ...