Hi!
I created a grafana managed alert as described below:
A - mysql query:
SELECT
tool_name,
data_value as ‘Health’,
timestamp as time
FROM
tool_data
WHERE
(key = ‘oldHealth’ or key = ‘newHealth’)
AND
Other constraints removed
ORDER BY
timestamp ASC
B - Reduce Count(A), drop non-numeric values
C - Math
Check value of B, alert based on result.
Here is what I want to do next:
tool_name is my metric column.
I am always expecting 5 tool names to come up for this alert, the multi series alert should always have 5 tool names with data. Sometimes when a tool is down I see less than 5.
Can I alert based on how many metrics are used? (Not exactly sure how to phrase that.) If the result of A is something like: A1 - 100, A2 - 101, A3 - 99
I want to know that there are only three 'A’s showing up instead of 5 and I want to get an alert.
Thanks for taking a look!