Skip to content

Open-source status page, incident response and uptime monitoring

777 B
Raw Blame
TOKEN "endpoint__http_uptime_7d__v1_endpoint_read_4195" READ

NODE endpoint
SQL >

%
SELECT 
    toStartOfInterval(time, INTERVAL {{ String(interval, '30', required=True) }}  minute) AS interval,
    countIf(requestStatus = 'success') AS success,
    countIf(requestStatus = 'degraded') AS degraded,
    countIf(requestStatus = 'error') AS error
FROM mv__http_uptime_7d__v1
WHERE
    monitorId = {{ String(monitorId, '1', required=True) }}
    {% if fromDate %} AND time >= parseDateTimeBestEffortOrNull({{ String(fromDate) }}) {% end %}
    {% if toDate %} AND time <= parseDateTimeBestEffortOrNull({{ String(toDate) }}) {% end %}
    {% if regions %} AND region IN {{ Array(regions, 'String', 'ams,fra') }} {% end %}
GROUP BY interval
ORDER BY interval DESC

TYPE endpoint