Hello everyone. I have a boot in a telegram group, which is working fine since I do the notification test in the Alerting → alert rules section.
Actually, I have to evaluate if a parameter exceeds a value (is bigger than 0), but since to use alerts I have to use a time series, the value is replicated in different time values.
This is the sql query:
with funcion as( SELECT id_unit, plate, fleet , supplier, can_blackout, gps_blackout
FROM tlm.main_dash_tele_all_vehicle_freq_blackout(
$__timeFrom()::timestamp,
$__timeTo()::timestamp
) WHERE supplier is NOT null AND model is NOT null
)
SELECT ( SELECT ($__timeFrom()::timestamp)) AS "time",
COUNT(funcion.can_blackout)+COUNT(funcion.gps_blackout) as "metric"
FROM funcion
UNION
SELECT ( SELECT $__timeFrom()::timestamp + (($__timeTo()::timestamp - $__timeFrom()::timestamp)/4 )) AS "time", COUNT(funcion.can_blackout)+COUNT(funcion.gps_blackout) as "metric" FROM funcion
UNION
SELECT ( SELECT $__timeFrom()::timestamp + ( ($__timeTo()::timestamp - $__timeFrom()::timestamp) /2 ) ) AS "time", COUNT(funcion.can_blackout)+COUNT(funcion.gps_blackout) as "metric" FROM funcion
UNION
SELECT ( SELECT $__timeTo()::timestamp - ( ($__timeTo()::timestamp - $__timeFrom()::timestamp) /4 ) ) AS "time", COUNT(funcion.can_blackout)+COUNT(funcion.gps_blackout) as "metric" FROM funcion
UNION
SELECT ( SELECT $__timeTo()::timestamp ) AS "time", COUNT(funcion.can_blackout)+COUNT(funcion.gps_blackout) as "metric" FROM funcion
And this is the alert configuration:
the test rule state is pending so, I change the For parameter from 15s to 0 and with that
and with that, it change the state to “alerting”
But it does not send the telegram alert. Why it does not?
Thanks in advance