#support

ClickHouse Query for Status Code 400 Alerting

TLDR Spidey requested a ClickHouse query for status code 400 alerting. Srikanth advised using a query builder with the signoz_calls_total metric and the http_status_code IN 400 filter.

8mo

Join the chat

Apr 10, 2023 (8 months ago)

Photo of md5-41d5df931f6be09b82374114ac1b6139

Spidey

07:16 AM

Hii team
Need to do exceptions based alerting
Can you share some clickhouse query for status code 400

Photo of md5-1899629483c7ab1dccfbee6cc2f637b9

Prashant

11:55 AM

cc Srikanth

Photo of md5-ce04a9988e2fd758a659dc55be6f2543

Srikanth

03:04 PM

You may not need a ClickHouse query for things such as 400 HTTP status code. You can use the query builder with metric signoz_calls_total and the filter http_status_code IN 400

SigNoz Community

Built with ClickHouse as datastore, SigNoz is an open-source APM to help you find issues in your deployed applications & solve them quickly | Knowledge Base powered by Struct.AI

Indexed 1023 threads (61% resolved)

Join Our Community

Similar Threads

Creating Alerts for HTTP Query in Signoz v0.18

Guillaume is trying to create an alert for a specific URL using Signoz v0.18. vishal-signoz suggests using Clickhouse queries, but Guillaume experiences issues with loading them.

7mo

Incorrect Alert Firing Issue in Threshold Condition

Harshith.R.S is experiencing an issue with alerts firing when the value is above the threshold. The issue remains unresolved after trying different query modifications suggested by Amol.

9mo

Creating Alerts Based on Custom Exception Messages

ma asked how to create alerts from custom exception messages. Pranay suggested using trace data but Srikanth clarified that exceptions are stored separately and suggested using a ClickHouse query instead, providing an example.