Capturing event data?

[denis]

When a device is properly connected to the hub, it generates events, as seen when clicking the Events Box. Like, motion, contact, temperature, illuminance, etc.

Is there a method to capture all this data to a CSV or TXT file? To give me the ability to analyse the data.

Thank you.

[Eric.C.Miller]

Hubitat > NodeRed > MySQL > Grafana (LONG READ)

Just a warning: This is a LONG read. I'm a NodeRed junkie for home automation tasks. I find it easy to do everything from network monitoring to rotating log files and firing off complex automations in Hubitat that I don't find Rule Manager suitable for. With that said, the topic here is getting your logs and events from your Hubitat hub and finally into Grafana. I chose Hubitat because I want everything running in my house locally (with some exceptions like Alexa/Google Home, etc). Part of tha…

[denis]

Thank you - that is what I'm looking for,

Got my work cut out.

[billmeek]

Denis,

If you are planning on using a Raspberry Pi, this might help a little bit:

Node-Red/InfluxDB/Grafana on Raspberry Pi 3

Here's an edited version of my notes for Node-Red/InfluxDB/Grafana on Raspberry Pi 3: ################################################################################ # This is a guide to installing Node-Red/InfluxDB/Grafana on a Raspberry Pi3 # along with a static IP address either configured on the RPI or (my personal # preference) on the router. # # It may work on other models except the RPi Gen 1 and zero models which do not # have ARM7. This guide assumes that you already have Raspbian …

[denis]

Yes, a few of them. I have a bunch of them in a drawer...

Thanks

[mpoole32]

Here's another method.

[billmeek]

Well understood. Starting to use Hubitat has made me actually utilize a couple of RPi3 that were just sitting in a storage box along with some Western Digital Pi Drives I had bought, tested, and then really didn't have a need for later.

[asj]

Depending on what you want to analyze it for here's another option I did. Dumps it into influxdb where you can pull it out, and slice and dice it.

New Hubitat to InfluxDB Bridge via MakerAPI+Node [beta]

[JohnRob]

If you wish to startup without choosing a database, I did a similar project collecting data to a simple CSV file. It allows me to look at the data in Excel and see what my next step might be. Somethings I'm simply looking for an issue and don't need to plot.

My description is there: DataCollection with NodeRed

[mike.howles]

Sorry for the possible slight thread necromancy here, but I wrote one for a buddy that writes out to a PostgreSQL DB and is Dockerized if anyone is interested.

entmike/hubitat-datacollector