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!

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 ...

New in Observability Cloud - Explicit Bucket Histograms

Splunk introduces native support for histograms as a metric data type within Observability Cloud with Explicit ...