Select Only new entries from Mssql

Hi,
Logstash is listening to MSSQL using JBCD connector ,
i want to make logstash select only new entires because i have millions of Tables , and select them all every time gonna make MSSQL so Slow .
so How can i make logstash select only new entries and if no new entries don't select anything?

You need to have an id or timestamp in your MSSQL table that identifiy the record
Then use sql_last_value param
https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html#_predefined_parameters

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