[RELEASE] Hub Information Driver v3

[juju]

Coming late to this party. Is there a workflow that takes all the data collected here and sends it to a grafana dashboard via influxdb? I have seen mention of nodered etc. but will like to get a birdseye view of what that workflow will look like. Data from here - > node red -> influx -> grafana? Any custom scripts in the middle?

Perhaps this is also not the possible but is prometheus a possibility in this scenario? Just poking around to see whats possible. Thxx

[thebearmay]

Generally people are using MakerAPI (w/Node Red) or InfluxDB Logger to get data into Influx or another DB and then use Grafana to do the visualizations. If you are using webCoRE it can also access and graph the data using its long term storage option.

As to Prometheus, no reason you couldn't send it there also, but not aware of a direct integration currently. My initial thought would be to use MakerAPI to do the extract, NodeRed to do the transform and load into Prometheus (assuming there are nodes available).

[herbknowlson]

As a new user it wasn't obvious what tile template to use. After some trial and I error I discovered "Attribute"

Maybe you can add to the NOTE FOR NEW USERS:

[672southmain]

@herbknowlson

As a new user it wasn't obvious what tile template to use. After some trial and I error I discovered "Attribute"

I believe that information is in the first paragraph of the first post in this thread:

@thebearmay

and the generation of an html attribute for display on a dashboard (template is a text file that may be edited to allow customization of the content).

[herbknowlson]

Thanks for the quick reply;

I was looking for a statement like:

When adding a dashboard tile for this device and it asks you "Pick a Template" then choose "Attribute". It then gives you a choice "Pick an Attribute".

Maybe this will help some others.

Thanks
Herb

[jtp10181]

@juju

Is there a workflow that takes all the data collected here and sends it to a grafana dashboard via influxdb?

Here is a direct link to a post about getting InfluxDB Logger setup. You will need to enabled the advanced mode to send the attributes you want.

Using HE with with InfluxDB, Grafana, with InfluxDB Logger

Using HPM download InfluxDB Logger from the Community github Repository. Once you have InfluxDB Logger loaded via HPM you will need to add the app to the hub by clicking on the "Add User App" button in the upper right corner and select "InfuxDB Logger" from the list that appears. This will install the smartapp on the hub and take you into the initial setup screen shown below [image] So lets us step through the setup of each part of the app. The application name will default to InfluxDB, but…

Here is some dashboards I have been working on, one of which uses the this driver:

Ready-to-Use Grafana Dashboards! - Beta Test / Feedback

Working on building these to share, to work in conjunction with the InfluxDB Logger app. InfluxDB2 (Flux) Required by default, some are ported to work on 1.x (InfluxQL). Data Source for Flux must be setup in Grafana using Query Language: Flux Easy drop down menus at the top to configure for your setup. Support for alternate device name Tags if you are not using InfluxDB Logger. Supports multiple hubs being fed to same bucket. Download info at bottom of post How to import a dashboard: Manag…

[mboisson]

Hi,
Thanks for this driver. I've been wanting to track hub attributes for a while now.

One question, for DB Size, is it normal that it seems to be an integer, and it varies widely between 4 and 14MB ?

[jtp10181]

@mboisson

and it varies widely between 4 and 14MB ?

Yes thats similar to my hub, it will spike up and down a lot as data gets logged and then the cleanup runs.

[jshimota]

lol 4 to 14 is teeny. i remember 200+ days...

[mboisson]

Ok, thanks. I guess I don't understand what "dbSize" is... I would expect the size of the database to be rather constant (or growing)...

[mboisson]

I just started recording hub info, so I am still learning what things mean

[thebearmay]

Database holds all of your app and device settings as well as events. The events get trimmed to the max setting you've designated once an hour, thus the DB grows and then shrinks over time.

[mboisson]

@thebearmay

Database holds all of your app and device settings as well as events. The events get trimmed to the max setting you've designated once an hour, thus the DB grows and then shrinks over time.

Where is that setting ?

Is this the size of the logs ?

It seems to get trimmed a lot more frequently than once an hour.

[thebearmay]

Settings are on the device pages near the bottom.

[mboisson]

So, these are for each device ? Is there a point to increase that from 1 ?

[sburke781]

One reason to keep it a little higher is so you can review Events in the Events page for the device when troubleshooting. If you left it at 1 you would only see the most recent change.

[thebearmay]

Can't remember but believe the default is about 200, I have most of mine at 10.

[mboisson]

I have never changed that, and mine is 11/30 for all devices.

[sburke781]

I think in the beginning... there was no setting and it may have been fixed, then the per-device settings were made available so people could keep the data kept for particularly chatty devices at a reasonable level, or, on the flip-side of that, reduce the number of times the events need to be reduced (by having a larger value in the setting), thus reducing the amount of work the hub needs to do on a regular basis.

I think there may be a way to apply the same setting across all devices, but am not 100% sure on that...

[rjterry21]

@sburke781

I think there may be a way to apply the same setting across all devices, but am not 100% sure on that...

(New defaults shown)

/hub/advanced/event/limit/11
/hub/advanced/deviceStateHistorySize/31