I previously used the Influxdb Logger app to send my device info out to an influxdb database. I would then use Grafana to create graphs,etc. Unfortunately it was one of the reasons my hub was locking up on a weekly basis. Thankfully @corerootedxb shared a better way to access device data and send to a database.
HE has an undocumented websocket that streams all events (it's what is probably used for the dashboards). We can tap this event stream using Node Red and push the events into a database. I already had influxdb set up so that's where my data goes.
If you are not familiar with Node Red, influxdb or Grafana, you may have a bit of reading to do. None of it is difficult on its own but setting all three from scratch may seem overwhelming. It's not so bad if you do one at a time. Each is a powerful tool in their own right.
Here's @corerootedxb thread with how to get the eventsocket setup in Node red and sent to a database.
Hubitat > NodeRed > MySQL > Grafana (LONG READ)
Within that thread there are posts with how to go to influxdb instead of an SQL database. Post any questions about how to get these going there.
