I'm trying to use the Microsoft SQL sensor to tell me if I find a certain value in the database. Now my simple approach was to use an SQL like this one: SELECT * FROM table WHERE value = myUnwantedValue
So if I use the sql and simply select "Count table rows" for data processing. The sensor goes into error state if no rows are returned and says: "No valid datatable was returned".
Now if the table contains rows the sensor turns green and I can send an email if the value exceeds more than 0 rows, but this is not what I want.
How can I set a sensor to error if my sql returnes rows and let it be green if no rows are returne without using lookups?