https://community.splunk.com/t5/Getting-Data-In/Splunk-DB-Connect-3-1-1-Why-database-input-for-MS-SQL-server/m-p/428868#M100255 <P>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.</P> <P>Below is the setting in db_inputs.conf but i have configured it through the GUI.</P> <P>[data-SQL]<BR /> connection = data-SQLconnection<BR /> disabled = 0<BR /> host = data-SQL<BR /> index = av<BR /> index_time_mode = current<BR /> interval = 60<BR /> mode = batch<BR /> query = SELECT * from<BR /><BR /> source = data-SQL<BR /> sourcetype = data:sql</P> <P>i appreciate for any advices.<BR /> Thanks</P> Tue, 29 Sep 2020 21:02:46 GMT nbtsplunk 2020-09-29T21:02:46Z https://community.splunk.com/t5/Getting-Data-In/Splunk-DB-Connect-3-1-1-Why-database-input-for-MS-SQL-server/m-p/428868#M100255 <P>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.</P> <P>Below is the setting in db_inputs.conf but i have configured it through the GUI.</P> <P>[data-SQL]<BR /> connection = data-SQLconnection<BR /> disabled = 0<BR /> host = data-SQL<BR /> index = av<BR /> index_time_mode = current<BR /> interval = 60<BR /> mode = batch<BR /> query = SELECT * from<BR /><BR /> source = data-SQL<BR /> sourcetype = data:sql</P> <P>i appreciate for any advices.<BR /> Thanks</P> Tue, 29 Sep 2020 21:02:46 GMT https://community.splunk.com/t5/Getting-Data-In/Splunk-DB-Connect-3-1-1-Why-database-input-for-MS-SQL-server/m-p/428868#M100255 nbtsplunk 2020-09-29T21:02:46Z