Commande worked before a drop series

Grafana InfluxDB
1

  • What Grafana version and what operating system are you using?
    Debian 12, grafana 10.0.2, influxdb 1.8.10

  • What are you trying to achieve?
    have datas from my VMs

  • How are you trying to achieve it?
    Use a template that worked before a reset

  • What happened?
    I rescently reseting datas from influxDB with the line “DROP SERIES FROM /.*/”
    and in grafana, the metrics “running VMs” don’t show me anymore the uptime of my VMs

The commande was “SELECT last(uptime) AS “uptime” FROM “system” WHERE (“object” = ‘qemu’) AND (“nodename” =~ /^$server$/) AND time > (now() - 10m) AND uptime > 0 GROUP BY “host” limit 1”
But that show me anything atm (worked before the drop)

If someone have a solution… Thanks a lot