Hello I need help with one thing. I'm trying to set up a SigNoz Alert. When an error occurs with http.status_code greater than 500, I want to send a message to Slack, and I want to include service_name, status_code, exceptionMessage, and exceptionStackTrace in the Alert Description, but I don't know how to do it. I gave up after trying. Please help me.

from my eye https://signoz.io/docs/userguide/alerts-management/

@Ross No, there is no answer As far as I have checked, http.status_code is in signoz_traces.distributed_signoz_index_v3 DB, and exceptionMessage and exceptionStackTrace seem to be loaded in signoz_traces.distributed_signoz_error_index_v2 DB. I wonder if I should use ClickHouse Query method to JOIN the two DBs to create the Alert Description I want, and then compare traceid and spanid to see if they are the same, and send only those with errors greater than 500.

not sure im new to it as well.. evaluating it.. but if even that simple usecase is difficult..

Hi @박형규, That's not possible today. Joining tables is going to be inefficient. I suggest you to set up a exception based alert and write the query to ignore the exception that happen outside 500.

@Srikanth Chekuri The exception base alert refers to signoz_traces.distributed_signoz_error_index_v2 and I can't ignore the 500 code because there is no table in that DB to reference http.status_code. Is there any way to do it?

Hi @박형규, I meant you would know the list of exception types that throw 4xx and exclude them from the exception type. The status code is not directly available on signoz_error_index