# No data load by logstash on sqlserver database

**URL:** <https://discuss.elastic.co/t/no-data-load-by-logstash-on-sqlserver-database/160213>\
**Category:** Logstash\
**Created:** [December 10, 2018, 4:15pm UTC](https://discuss.elastic.co/t/no-data-load-by-logstash-on-sqlserver-database/160213 "2018-12-10T16:15:49Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Michel](https://avatars.discourse-cdn.com/v4/letter/m/ea666f/32.png) [@Michel](https://discuss.elastic.co/u/Michel)\
**Post date:** [December 10, 2018, 4:15pm UTC](https://discuss.elastic.co/t/no-data-load-by-logstash-on-sqlserver-database/160213/1 "2018-12-10T16:15:49Z")

</div>

Hi, I installed logstash as a service on a redhat 7 server, everything seems to be correctly configured, but logstash does not load anything. I asked him to ask every minute, but nothing happens !

My logstash.conf :

input {  
jdbc {  
jdbc\_driver\_library =\> "sqljdbc42.jar"  
jdbc\_driver\_class =\> "com.microsoft.sqlserver.jdbc.SQLServerDriver"  
jdbc\_connection\_string =\> "jdbc:sqlserver://SQL/PRD:1433;databaseName=MaBase;integratedSecurity=true;"  
jdbc\_user =\> "user"  
jdbc\_password =\> "pass"  
schedule =\> "1 \* \* \* \*"  
statement =\> "SELECT datetime, probename, customer, host, servicename, target, availability, setuptime, responsetime, transfertput, metric\_1, metric\_2, metric\_3, metric\_4, metric\_5, metric\_6, metric\_7, metric\_8, interval, slo\_violations FROM MaBase dat where (datetime) in (SELECT max(datetime) FROM MaBase dat2 where datetime \> (select cast(getDate() As Date)) and dat.servicename=dat2.servicename group by servicename) order by servicename;"  
}  
}

input {  
beats {  
port =\> 5044  
}  
}

output {  
elasticsearch {  
hosts =\> ["[http://susis:9200](http://susis:9200)"]  
index =\> "%{[@metadata][beat]}-%{[@metadata][version]}-%{+YYYY.MM.dd}"  
}  
}

the query works very well and brings back a 100 of records. It is scheduled every minute.

My logstash.yml :  
config.debug: true  
log.level: debug

My Logstash-plain.log en mode DEBUG does not signal any problem !

How can i see what logstash does ?

Where do we have to look to follow logstash activity?

Thanks for your Help, Michel.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [January 7, 2019, 4:15pm UTC](https://discuss.elastic.co/t/no-data-load-by-logstash-on-sqlserver-database/160213/2 "2019-01-07T16:15:53Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.