input {
    jdbc {
        jdbc_driver_library => "PATHsqljdbc42.jar"
        jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
        jdbc_connection_string => "jdbc:sqlserver:CONNSTRING"
        jdbc_user => "****"
        jdbc_password => "****"
        statement => "SELECT * FROM [db].[dbo].[Logs] WHERE LogID > :sql_last_value"
        use_column_value => true
        tracking_column => logid
        clean_run => true
    }
}
output {
    elasticsearch {
        hosts => ["HOST:PORT"]
        index => "logs"
        document_type => "logentry"
        document_id => "%{logid}"
    }
}