wwerther

blueprint:
  name: ☎ AWTRIX - FritzBox Call Notification
  description: |-
    Blueprint for use with Awtrix and Fritz-Box as Callmonitor. 
    Based on other flows that I found.

    To make it work you need to add an instance of the Fritz!Box CallMonitor integration
    if not already done.  And of course you need to activate the Call-Monitor Service
    on your Fritz-Box. Otherwise the events will not be created and calls will not
    be shown.

wwerther

---
blueprint:
  name: ☼ AWTRIX - SolarEdge Energy Monitor
  description: >
    This blueprint will show the current solar energy received, the amount of energy consumed by the household,
    and the amount of energy stored in the battery.

    The following icons are needed on your Awtrix
      battery
        discharge:  21586

wwerther

blueprint:
  name: Awtrix Test
  description: >
    Test Blueprint for use with Awtrix. Based on https://flows.blueforcer.de/flow/6wqGQAmP5pe0
  domain: automation 
  author: Walter
  input:
    awtrix:
      name: AWTRIX Device
      description: Select the Awtrix light

wwerther

wwerther

const axios = require('axios').default;

const influxDbInstance = 'influxdb.0';
const token = 'xxxxxxxxxxxxxxxxxxxx';
const measurement = 'energy-stats';

const influxDbInstanceConfig = await getObjectAsync(`system.adapter.${influxDbInstance}`);

const protocol = influxDbInstanceConfig.native.protocol;
const host = influxDbInstanceConfig.native.host;

wwerther

const axios = require('axios').default;

const influxDbInstance = 'influxdb.0';
const token = 'xxxxxxxxxxxxxxxxxxxxxx';
const measurement = 'energy-stats';

const loggingTemplate = {
    'awattar.0.Rawdata': 'awattar',
    //{"object":"list","data":[{"start_timestamp":1687392000000,"end_timestamp":1687395600000,"marketprice":115.49,"unit":"Eur/MWh"},{"start_timestamp":1687395600000,"end_timestamp":1687399200000,"marketprice":111.34,"unit":"Eur/MWh"},{"start_timestamp":1687399200000,"end_timestamp":1687402800000,"marketprice":107.02,"unit":"Eur/MWh"},{"start_timestamp":1687402800000,"end_timestamp":1687406400000,"marketprice":115.75,"unit":"Eur/MWh"},{"start_timestamp":1687406400000,"end_timestamp":1687410000000,"marketprice":137.62,"unit":"Eur/MWh"},{"start_timestamp":1687410000000,"end_timestamp":1687413600000,"marketprice":152.72,"unit":"Eur/MWh"},{"start_timestamp":1687413600000,"end_timestamp":1687417200000,"marketprice":153.94,"unit":"Eur/MWh"},{"start_timestamp":1687417200000,"end_timestamp":16874208000

wwerther

diff --git a/sql/empty.sql b/sql/empty.sql
index 129af9e..179d82f 100755
--- a/sql/empty.sql
+++ b/sql/empty.sql
@@ -355,7 +355,7 @@ CREATE TABLE `my_tc_users` (
   `last_pw_change` datetime default NULL,
   `birthday` date default NULL,
   `idnumber` varchar(40) default NULL,
-  `last_login` datetime NOT NULL default '',
+  `last_login` datetime NULL,

wwerther

$computer='remote.example.com';
$servicename='TheServiceName';

$cred=Get-Credential;

function getsrv($servicename,$computer,$credentials) {
    $servicename="Name='" + $servicename + "'";
    return Get-WmiObject -Class Win32_Service -computer $computer -Credential $credentials -filter $servicename;
}

wwerther

REGEDIT4

[HKEY_CLASSES_ROOT\biss]
@="URL:biss Protocol"
"URL Protocol"=""

[HKEY_CLASSES_ROOT\biss\shell]

[HKEY_CLASSES_ROOT\biss\shell\open]