SigNoz is an open-source APM. It helps developers monitor their applications & troubleshoot problems, an open-source alternative to DataDog, NewRelic, etc.

SigNoz Community

image.png

<#C01HWQ1R0BC|support> how to create new alert based on some custom message in exception? For example I want to filter by exception.type . How to write the query

exceptions.png

Have you tried creating alerts based on traces, as exceptions data is available in traces

<@U01HPVB0D2S> that's not possible because exceptions are stored separately and can't be searched. Only tags are usable in the traces. <@U05MRSWG4ER> alternative is to write ClickHouse query. You can find examples here <https://signoz.io/docs/tutorial/writing-clickhouse-queries-in-dashboard/>.
example
```SELECT count() AS value, toStartOfInterval(timestamp, INTERVAL 5 MINUTE) AS interval 
FROM signoz_traces.signoz_error_index_v2 
WHERE timestamp BETWEEN {{.start_datetime}} AND {{.end_datetime}} 
AND (serviceName = 'api-service') 
AND (exceptionType = 'Not found') 
GROUP BY interval```