Differences

This shows you the differences between two versions of the page.

--- smart-home [2024/05/02 02:57] – [Home assistant] admin
+++ smart-home [2025/03/10 04:06] (current) – [Pantum M6500W] admin
@@ Line 1: / Line 1: @@
 ====== Smart home ======
+Контроллер - https://www.owenkomplekt.ru/product/spk107-oven-panelnyy-programmiruemyy-kontroller-so-vstroennym-sensornym-ekranom-7/
+====== Smart Home docker ======
+  * https://immich.app/ - photo
+  * https://wiki.servarr.com/prowlarr -  Lidarr, Prowlarr, Radarr, Readarr, Sonarr, and Whisparr docker
 ===== Smart home devices =====
 ^ Устройство                                                                                                                                                              ^ Технология  ^ Описание                                                                                                                                                                  ^ Ссылка                                                                                                                                                                                                                  ^ Дата        ^ Комментарий                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                ^
@@ Line 11: / Line 17: @@
   * своими руками https://dzen.ru/media/smart_home_russia/
   * Умный дом с Alex Kvazis - https://t.me/smarthomesell https://www.youtube.com/channel/UCcq9onYHbs6go3kDpfBoqhg
+  * https://www.smarthomebeginner.com/home-server/
+  * https://habr.com/ru/articles/799957/ - esphome датчик тепла, учета энергии, импульсов
+===== Проекты =====
+  * [[https://psenyukov.ru/%d1%81%d1%87%d0%b8%d1%82%d1%8b%d0%b2%d0%b0%d0%bd%d0%b8%d0%b5-%d0%bf%d0%be%d0%ba%d0%b0%d0%b7%d0%b0%d0%bd%d0%b8%d0%b9-%d1%81%d1%87%d0%b5%d1%82%d1%87%d0%b8%d0%ba%d0%be%d0%b2-%d0%b2%d0%be%d0%b4%d1%8b/|Считывание аналоговых счетчиков ]]
+==== Monitoring ====
+  * https://habr.com/ru/articles/817001/ Резервный мониторинг послушного дома
+===== HA Configuration =====
+  * https://github.com/to4ko/myconfig/
+  * https://github.com/avbor/HomeAssistantConfig
+#TODO
+sensors with battery list - https://simple-ha.ru/posts/468 \\
 ===== MQTT =====
   * [[https://www.youtube.com/watch?v=31IyfM1gygo|Good channel and video]]
@@ Line 24: / Line 45: @@
 ====== Home assistant ======
-https://github.com/frenck/awesome-home-assistant [[https://community.home-assistant.io/t/how-to-make-my-custom-card-wider-in-the-lovelace/619582| config energy]]\\
+https://www.awesome-ha.com/ [[https://community.home-assistant.io/t/how-to-make-my-custom-card-wider-in-the-lovelace/619582| config energy]]\\
+https://wiki.ip2u.ru/smart-home#home_assistant - multiroom \\
 ===== HA. install =====
 :!: HAAS [[https://haade.fr/en/blog/easy-installation-home-assistant-os-armbian-cubietruck-2024#preparing-for-haos|HAOS install on armbian]]  [[https://gadget-freakz.com/the-best-home-assistant-addons-and-repos-of-2023/|additional HAAS addons repository]] \\
@@ Line 58: / Line 80: @@
 https://sprut.ai/user/AlexAz/contents/articles \\
+===== HA mysql =====
+++++ Get stats of mysql - where data located|
+<code SQL>
+-- get count of state entity and count of history data
+SELECT
+    states_meta.entity_id,
+    count(*),
+   -- states.state,
+    from_unixtime(min(states.last_updated_ts)) as last_updated_ts,
+    from_unixtime(min(IF(states.last_changed_ts IS NULL,
+        states.last_updated_ts,
+        states.last_changed_ts))) AS last_changed_ts
+FROM
+    states
+        LEFT JOIN
+    states_meta ON (states.metadata_id = states_meta.metadata_id)
+group by states_meta.entity_id
+order by 2 desc;
+-- size of all tables
+SELECT table_schema as `DB`, table_name AS `Table`,TABLE_ROWS,
+  ROUND(((data_length + index_length) / 1024 / 1024), 2) `Size (MB)`
+  FROM information_schema.TABLES
+  ORDER BY (data_length + index_length) DESC;
+</code>
+++++
+===== HA - template =====
+<code BASH>
+# home assistant - executing in day 24h
+h 	24
+m 	144
+m 	288
+m 	1440
+s	17280
+s	86400
+{% set result = namespace(sensors=[]) %}
+{% set exclude = [] %}
+{% set hours = 1 %}
+{% for state in states.sensor | rejectattr('attributes.device_class', 'undefined') | selectattr('attributes.device_class', '==', 'timestamp') %}
+    {{state}}
+    {% if 'last_seen' in state.entity_id and not state.entity_id in exclude.entity_id and (states(state.entity_id) == 'unavailable' or ((as_timestamp(now()) - as_timestamp(states(state.entity_id))) > ((hours | int) * 60 * 60))) %}
+     {% set result.sensors = result.sensors + [state.name | regex_replace(find=' last seen', replace='') ~ ' (' ~ relative_time(strptime(states(state.entity_id), '%Y-%m-%dT%H:%M:%S%z', 'unavailable')) ~ ')'] %}
+    {% endif %}
+ {% endfor %}
+ {{ result.sensors | join(', ') }}
+</code>
 ======  OpenHAB ======
@@ Line 375: / Line 447: @@
 {{:smart-home:pasted:20240217-191414.png}}
+==== Pantum M6500W ====
+<code BASH>
+ snmpwalk -v2c -c ADDpubkeyAAA 192.168.5.52 .1
+iso.3.6.1.4.1.40093.1.1.3.12 = INTEGER: 345
+#SNMP OID for "Printed Pages Total"
+</code>
+Mib - {{ :pantum.mib.data-.bp5100.bm5100.series.xlsx |}}
+==== HP HP Color LaserJet Pro MFP M176n ====
+https://github.com/remetremet/SNMP-OIDs/blob/master/OIDs/Printer-HP-ColorLaserJetPro-MFP-M479.md https://mibs.observium.org/mib/HP-LASERJET-COMMON-MIB/#accounting \\
+<code BASH>
+< SNMPv2-SMI::enterprises.11.2.3.9.4.2.1.4.1.2.5.0 = Gauge32: 530
+< SNMPv2-SMI::enterprises.11.2.3.9.4.2.1.4.1.2.6.0 = Gauge32: 530
+< SNMPv2-SMI::enterprises.11.2.3.9.4.2.1.4.1.2.34.0 = INTEGER: 530
+< SNMPv2-SMI::enterprises.11.2.3.9.4.2.1.4.1.2.35.0 = INTEGER: 530
+---
+> SNMPv2-SMI::enterprises.11.2.3.9.4.2.1.4.1.2.5.0 = Gauge32: 531
+> SNMPv2-SMI::enterprises.11.2.3.9.4.2.1.4.1.2.6.0 = Gauge32: 531
+> SNMPv2-SMI::enterprises.11.2.3.9.4.2.1.4.1.2.34.0 = INTEGER: 531
+> SNMPv2-SMI::enterprises.11.2.3.9.4.2.1.4.1.2.35.0 = INTEGER: 531
+</code>