https://signoz.io logo
Title
s

Srinivasan Manikantan

02/15/2023, 9:01 AM
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.
s

Srinivasan Manikantan

02/15/2023, 9:32 AM
ok thanks