Skip to content

Instantly share code, notes, and snippets.

View wwerther's full-sized avatar

Walter Werther wwerther

  • Germany
  • 12:19 (UTC +02:00)
View GitHub Profile
REGEDIT4
[HKEY_CLASSES_ROOT\biss]
@="URL:biss Protocol"
"URL Protocol"=""
[HKEY_CLASSES_ROOT\biss\shell]
[HKEY_CLASSES_ROOT\biss\shell\open]
@wwerther
wwerther / RestartService.ps1
Created June 25, 2011 07:07
restart remote services via Powershell
$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
wwerther / fix_lastlogin.patch
Created March 11, 2012 22:08
Patch Teamcal 3.3.009 -> Fix_Lastlogin
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
wwerther / trigger_awattar.js
Created June 23, 2023 20:36
IOBroker - Trigger Awattar 2 Influx
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
wwerther / fetch_awattar.js
Created June 23, 2023 20:38
Iobroker - Skript Awattar History 2 Influx DB
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
wwerther / iobroker_modbus_solaredge_sf.tsv
Last active July 27, 2023 19:58
IOBROKER - Modbus TCP Solaredge incl. SF
_address name description unit type len factor offset formula role room poll wp cw isScale
40001 SunSpecID C_SunSpec_ID uint32be 2 1 0 state true false false false
40003 SunSpecDID C_SunSpec_DID uint16be 1 1 0 state true false false false
40004 SunSpecLength C_SunSpec_Length uint16be 1 1 0 state true false false false
40005 Manufacturer C_Manufacturer string 16 1 0 state true false false false
40021 Model C_Model string 16 1 0 state true false false false
40045 Version C_Version string 8 1 0 state true false false false
40053 SerialNumber C_SerialNumber string 16 1 0 state true false false false
40069 DeviceAddress C_DeviceAddress uint16be 1 1 0 state true false false false
40070 PhaseTypes C_SunSpec_DID uint16be 1 1 0 state true false false false
@wwerther
wwerther / awtrix-test.yaml
Last active March 10, 2024 18:44
homeassistant-blueprint-awtrix-test
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 / awtrix-fritzcallmonitor.yaml
Last active March 20, 2024 19:28
awtrix-fritzcallmonitor.yaml
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
wwerther / awtrix-solaredge.yaml
Last active April 5, 2024 14:10
AWTRIX - Solaredge with batterie
---
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.
Based on https://flows.blueforcer.de/flow/YjJZo6m7AyrL
Uses entities provided by https://github.com/Remko76/hasolarcfg/tree/master