Openstatus
www.openstatus.dev
1VERSION 0
2
3TAGS tcp
4
5NODE endpoint
6SQL >
7
8 %
9 SELECT time as day, countMerge(count) as count, countMerge(ok) as ok
10 FROM mv__tcp_status_7d__v0
11 WHERE
12 monitorId = {{ String(monitorId, '1', required=True) }}
13 GROUP BY day
14 ORDER BY day DESC
15 WITH FILL
16 FROM
17 toStartOfDay(toStartOfDay(toTimeZone(now(), 'UTC')))
18 TO toStartOfDay(
19 date_sub(DAY, 7, now())
20 ) STEP INTERVAL -1 DAY
21
22
23TYPE ENDPOINT