Does anyone have expertise on the influxdb database structure? I am trying to get a simple query that returns the date of the last update, and the friendly name of the device (for all devices).
I have an InfluxDB connected to Grafana, and I have very novice dashboards for temperature and other things.
My problem has been that occasionally, a sensor stops sending data, and I don’t get any warning. I have tried to create automation to notify me (using some ideas I found here in the forum) and even create a mushroom card showing the last update, but I have not been successful. So, I was thinking that a simple query would do the trick, but I am having a hard time with flux.