New Project: Hubitat System Metrics (Node Red, SQL, Grafana)
Objective: Create a storage and reporting system for all configured exportable data, events and logs.
Calculate historical system metrics across all system component domains.
- Application Level Logs
- Device Logs
- System Logs (all data)
- Event Logs (all data)
- All logs are captured and pinned to local time, with environmental #s (temp, humidity, etc..) as well as configurable Secondary and Tertiary Input devices. You pick the two devices, the commands and configure the responses headers.
- Archive system backups as BLOB into the database (extreme waste of storage space? Let's see)
Reporting: Grafana and possibly tabular output using a web based Crystal Report configured dynamically system devices, applications,etc...
SQL Server: To be honest I have to do a little leg work to determine the storage capacity requirements for a "larger" system, exporting 100% of all available log activity stored 24/7/365
Side-note: The completion of this project assumes my Hubitat doesn't have a stroke with all the extra logging turned on.
For some time I experienced what I interpreted as a "bogged down system"
After digging in I realized I had a LOT of logging features turned on, as well as many devices needing clean-up from dropped devices to non-functional z-wave repeaters , broken rules ,etc..
Either way.. Those problems have all been long resolved. What caused the bogged down system initially? IDK. I didn't address each problem and retest the system performance. I will fully evaluate if that problem were to return.
Matt