Im looking at getting my existing sensors migrated to v2 , struggling with the first one though and its very simple.
Its a replication check to ensure slave services are running, i current just run the below query and use post processing options to verify it.
here is the query, it returns 'off' or 'on'
|select variable_value from information_schema.global_status where variable_name='slave_running';|
In mysql v2 , i created the sql file but i cant find options to valid date response, i get an error with everything i have tried.
How can set status based on this on/off response ?