How do I write a database query for a DB Collector that uses state-tracking for MS SQL?
Eric Reusche
Posts: 40 ✭✭
in Stream
How do I write a database query for a DB Collector that uses state-tracking for MS SQL?
0
Best Answer
-
Looking at https://docs.cribl.io/stream/collectors-database#tracking-column, the example is:
SELECT * FROM my_table WHERE ${state && state.id ?id > ${state.id.value}: '1 = 1'} ORDER BY id0
Answers
-
Looking at https://docs.cribl.io/stream/collectors-database#tracking-column, the example is:
SELECT * FROM my_table WHERE ${state && state.id ?id > ${state.id.value}: '1 = 1'} ORDER BY id0