Getting Data In
×

Join the Conversation

Without signing in, you're just watching from the sidelines. Sign in or Register to connect, share, and be part of the Splunk Community.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Ask a Question

Splunk DB Connect 3.1.1 - Why database input for MS SQL server query does not capture any data to the index?

nbtsplunk
Loves-to-Learn Lots
‎08-28-2018 01:33 PM

i have setup a database input to connect to MS SQL server in Splunk DB connect 3.1.1. My database connection is working fine and I just tested a simple query like "select * from " but no data has been collected and indexed in my new index. i did not see any errors from any log.

Below is the setting in db_inputs.conf but i have configured it through the GUI.

[data-SQL]
connection = data-SQLconnection
disabled = 0
host = data-SQL
index = av
index_time_mode = current
interval = 60
mode = batch
query = SELECT * from

source = data-SQL
sourcetype = data:sql

i appreciate for any advices.
Thanks

Tags (1)
0 Karma
Reply
Get Updates on the Splunk Community!

[Puzzles] Solve, Learn, Repeat: Dynamic formatting from XML events

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...

Enter the Agentic Era with Splunk AI Assistant for SPL 1.4

  🚀 Your data just got a serious AI upgrade — are you ready? Say hello to the Agentic Era with the ...

Stronger Security with Federated Search for S3, GCP SQL & Australian Threat ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...