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!

Splunk Classroom Chronicles: Training Tales and Testimonials

Welcome to the "Splunk Classroom Chronicles" series, created to help curious, career-minded learners get ...

Access Tokens Page - New & Improved

Splunk Observability Cloud recently launched an improved design for the access tokens page for better ...

Stay Connected: Your Guide to November Tech Talks, Office Hours, and Webinars!

🍂 Fall into November with a fresh lineup of Community Office Hours, Tech Talks, and Webinars we’ve ...