Leioder gehen meine Grafana abfragen nciht mehr... hast DU eine Idee ?
Beispiel:
(select ts_to_unix(ts) as time, "VALUE" as inetdown, 'Internet Home Download' as metric from D_SYSVAR_54225_VALUE
where ts >= unix_to_ts($unixEpochFrom()) and ts < unix_to_ts($unixEpochTo()) and "VALUE" > 0
union
(select $unixEpochFrom() as time, "VALUE" as inetdown, 'Internet Home Download' as metric from D_SYSVAR_54225_VALUE
where ts = (select max(ts) from D_SYSVAR_54225_VALUE where ts <= unix_to_ts($unixEpochFrom()) and "VALUE" > 0 ) )
union
(select $unixEpochTo() as time, "VALUE" as inetdown, 'Internet Home Download' as metric from D_SYSVAR_54225_VALUE
where ts = (select max(ts) from D_SYSVAR_54225_VALUE where ts <= unix_to_ts($unixEpochTo()) and "VALUE" > 0 ) )
)order by time
Vielleicht kannst Du mir helfen :-)
lg Richard
PS: value habe ich auf "VALUE" geändert ....
roe1974
commented
2 years ago
Hallo Marthias
Leioder gehen meine Grafana abfragen nciht mehr... hast DU eine Idee ? Beispiel:
(select ts_to_unix(ts) as time, "VALUE" as inetdown, 'Internet Home Download' as metric from D_SYSVAR_54225_VALUE where ts >= unix_to_ts($unixEpochFrom()) and ts < unix_to_ts($unixEpochTo()) and "VALUE" > 0 union (select $unixEpochFrom() as time, "VALUE" as inetdown, 'Internet Home Download' as metric from D_SYSVAR_54225_VALUE where ts = (select max(ts) from D_SYSVAR_54225_VALUE where ts <= unix_to_ts($unixEpochFrom()) and "VALUE" > 0 ) ) union (select $unixEpochTo() as time, "VALUE" as inetdown, 'Internet Home Download' as metric from D_SYSVAR_54225_VALUE where ts = (select max(ts) from D_SYSVAR_54225_VALUE where ts <= unix_to_ts($unixEpochTo()) and "VALUE" > 0 ) ) )order by time
Vielleicht kannst Du mir helfen :-) lg Richard PS: value habe ich auf "VALUE" geändert ....