Is it possible to manipulate the ID in SQL queries done by NXLog agent? The documentation states this in im_dbi module:
The module automatically appends a WHERE id > ? LIMIT 10 clause to the statement. The result set returned by the SELECT statement must contain an id column which is then stored and used for the next query.
I have a database that does not get new reqords very often so i want to reset that id for testing and development purposes in the receiving end.