For Fibaro Lite/HC2 Python Service.
This Python Service (Running also on Raspberry) can be used to Export Sensors (Devices) and values from Fibaro Lite/HCto an Influxdb Database for further actions like, Grafana Dashboards, Statistics,etc. Inside .py File you can complete the API/DB details (IP, Usern,Pass, DBName) and you are done.
Dependencies for Python: sudo pip install influxdb more details here: https://github.com/influxdata/influxdb-python
sudo pip install mysql-connector-python
more details here: https://pypi.org/project/mysql-connector-python/
*New
Integration with Zabbix https://www.zabbix.com/ and mysql as for network devices bandwidth collection through SNMP. In order to get this information please go to line #672 and fulfill the object ids. You can easily find the ID's from mySQL - table zabbix_history, example: [SELECT * FROM zabbix.history_uint]. For Grafana there is a plugin for Zabbix details here: https://grafana.com/plugins/alexanderzobnin-zabbix-app
More Updates and Devices are in Roadmap.
Devices that are used (i believe that more can be used *not tested): 1. Fibaro Motion (Multisensor) Sensor *(z-wave) 2. Fibaro Dimmer 2 *(z-wave) 3. Power Plug Switch NEO Coolcam *(z-wave) 4. Smoke Detector NEO Coolcam *(z-wave) 5. Door Sensor NEO Coolcam and Fibaro *(z-wave) 6. Remotec AC Infrared Control *(z-wave) 7. TBK-HOME Light Switch Dimmer *(z-wave) 8. Motion Sensor NEO Coolcam *(z-wave) 9. Philio Temperature/Humidity Sensor *(z-wave) 10. Swiid Inter Cord Switch *(z-wave)
AZURE IOT HUB Support New Version with Azure IOT HUB support. Just insert your Azure IOT Hub Properties in [ImportFibaroItems.py] file and you are ready to send IoT messages (JSON) through, IotHub RestAPI. You can sign up to Microsoft Azure for a free trial here: https://azure.microsoft.com/en-us/offers/ms-azr-0044p/
Microsoft Azure Services that being used:
- Azure IOT Hub.
- Azure Stream Analytics.
- Azure Machine Learning.
- Azure Functions.
- Azure Table Storage.
- Azure Logic App.
- Azure Service Bus.
*Updated Version
- New json Object Format (Integration for Azure Machine Learning)
- Azure Stream Analytics Queries for Table Storage and Power BI API.
- Home Network Bandwidth new Object for analytics and visualization.
- Power BI API Support
- Serverless Logic App and Service Bus for Notification in mobile/mail/sms/etc
- Home Behavior Analytics with PCA- Anomaly Detection. Trained Model (In Azure ML Gallery Soon)
Power BI Pictures
ROADMAP
- *Under Development Home Behavior Analytics with PCA- Anomaly Detection. Trained Model coming soon...
- *Under Development Serverless Function for Device Recognition (Power Consumption)