Unreliable InfluxDB size sensor

[e-raser]

Just a backlink as I was looking for the same.

InfluxDB information (database size) as sensor in Home Assistant

Hi, as many others (searched the forum, few requests with different information but all without a solution) I struggle to successfully define an InfluxDB sensor to be used in Home Assistant. I want to get the current InfluxDB database size of homeassistant . My query is: SELECT sum("diskBytes") FROM "_internal".."tsm1_filestore" WHERE time >= now() - 7d AND "database"='homeassistant' GROUP BY time(30s), "database" What does the sensor definition in my configuration.yaml need to look like? I…

In case anyone got a better solution… let us know