2021-04-20 21:13:14 +00:00
|
|
|
# Home ASSistant
|
2020-11-26 17:38:25 +00:00
|
|
|
|
|
|
|
|
## instalation
|
|
|
|
|
|
|
|
|
|
``` yay home-assistant ```
|
|
|
|
|
|
|
|
|
|
- need mosquito broker for mqtt
|
|
|
|
|
|
|
|
|
|
## Cheatsheet
|
|
|
|
|
|
|
|
|
|
- [icon material](https://cdn.materialdesignicons.com/4.5.95/)
|
|
|
|
|
|
|
|
|
|
## event
|
|
|
|
|
|
2021-01-04 18:14:58 +00:00
|
|
|
- cube xiaomi xiaomi_aqara.cube_action
|
|
|
|
|
|
|
|
|
|
## SQL request
|
|
|
|
|
|
|
|
|
|
- get most use entity:
|
2021-04-20 21:13:14 +00:00
|
|
|
```SELECT entity_id, COUNT(*) as count FROM hass.states GROUP BY entity_id ORDER BY count DESC LIMIT 20```
|
