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!

Introducing Ingest Actions: Filter, Mask, Route, Repeat

WATCH NOW Ingest Actions (IA) is the best new way to easily filter, mask and route your data in Splunk® ...

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