All Apps and Add-ons

Why am I getting no results with Splunk DB Connect but with |dbquery I get results

LH_SPLUNK
Explorer

Hi,

I'm using Splunk DB Connect to connect Splunk with an MSSQL Database.

After I set identity and connection, I make an input.

With the |dbquery, I get my results but with the Host/Source/... I cannot see results.

I hope you can help.

LH

0 Karma

andrew_m_streic
New Member

Be sure to have the correct jdbc drivers and make sure they are installed in the correct location.
http://docs.splunk.com/Documentation/DBX/3.1.3/DeployDBX/Installdatabasedrivers

0 Karma

kmaron
Motivator

if you are using the DB Connect app to create your input you should be able to run it there and see what it returns.

Also, if the query is failing you should be able to see the return codes with index=_internal sourcetype=dbx_audit

0 Karma
Get Updates on the Splunk Community!

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...

What’s New in Splunk Security Essentials 3.8.0?

Splunk Security Essentials (SSE) is an app that can amplify the power of your existing Splunk Cloud Platform, ...