Time Series Grafana

Grafana Alerting
1

I have following as DB with following Tags and Fields
SHOW TAG KEYS
name: http
tagKey

Country
dbTag
endpointTag
pingTag
status
statusCode
url

SHOW TAG VALUES WITH KEY = “dbTag”
name: http
key value

dbTag f29fabe637a472bf5222b12a0bc5df77
dbTag fad58de7366495db4650cfefac2fcd61

SHOW TAG VALUES WITH KEY = “pingTag”
name: http
key value

pingTag 068ea8c10915701e0b416e67d5bfc70f

SHOW TAG VALUES ON “wss” WITH KEY IN (“dbTag”,“status”)
name: http
key value

dbTag f29fabe637a472bf5222b12a0bc5df77
dbTag fad58de7366495db4650cfefac2fcd61
status Down
status Up

SHOW FIELD KEYS
name: http
fieldKey fieldType

db string
endpoint string
pingName string

I wanted to sent alerts when statusCode is 0. Hence I have created query for timeseries graph. but no luck still now.
Now I wanted to plot statusCode on Timeseries graph ( Y axis as statusCode and X axis as time). I tried in many ways but I am not able to plot statusCode. Let me know what I am missing.

2

what version of grafana are you running? and are you using the legacy alerting platform or the new unified alerting platform that debuted in v8 and became the default in v9?