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