Rule to monitor device status ON/OFF and calculating total usage

[5iver (Scott Rushworth)]

Looks like you may have eberything firgued out, but here are some useful threads…

Counting number of values of an item in influxDB?

Hi, I would like to know how many times a light switch has been turned on of off. All the changes are stored in influxDB and I can see them when using influxDBstudio. How can I access this from openHab using one of the persistence extensions ? -ben

Time in state for an item - using persistence

Probably more a persistence question (which is influx in this case) If I’ve got values on and off for my alarm, or tv for example, I wouldn’t find trying to determing how long over the day that an item was in a state of on. Ideally I’d prefer to do this by by using the persistence layer I’m already using to do this rather than keeping variables in openhab. Has anyone tried this? Maybe pulled values from persistence and calculated that way, if not pulled a value direct from persistence via a …