hi, how to create an alert for an exception to notify on slack? I tried "Exception-based alert" but whatever query i write, nothing is returned
a
Amol Umbark
02/15/2023, 9:08 AM
can you share the query you have written.
s
Srinivasan Manikantan
02/15/2023, 9:10 AM
SELECT
count() as value,exceptionType,
serviceName
FROM signoz_traces.signoz_error_index_v2
WHERE exceptionType !='OSError'
AND timestamp > toUnixTimestamp(now() - INTERVAL 5 MINUTE)
GROUP BY serviceName,exceptionType;
a
Amol Umbark
02/15/2023, 9:28 AM
this query is pulling errors in last 5 mins . could it be due to no os error in that time
i would recommend testing query in clickhouse client and then pasting a working query in form.