Skip to content

Instantly share code, notes, and snippets.

View gitfvb's full-sized avatar
👋

Florian von Bracht gitfvb

👋
4 followers · 6 following
View GitHub Profile
@gitfvb
gitfvb / splatting.ps1
Created December 16, 2020 17:18
splatting in powershell
# this method allows a command execution with a hashtable instead of one big line
$restParams = @{
method = "Get"
uri = "https://www.google.de"
ContentType = "application/json"
verbose = $true
}
Invoke-RestMethod @restParams # note the @ instead of the $
@gitfvb
gitfvb / query.sql
Created December 9, 2020 08:18
db2 queries for loading a sliding window
SELECT *
,BIGINT (DATE) AS DATEERN -- this is used as ERN field
,CASE Kundennummer WHEN '0' THEN '9999'||lpad(dayofyear(date),4,'0') ELSE Kartennummer END CONCAT '|' CONCAT BIGINT (DATE) AS DateKey
FROM APTECO.BONS
WHERE DATE BETWEEN (
TIMESTAMP_FORMAT(CASE
WHEN @ERN < BIGINT (0)
THEN '20161231'
ELSE @ERN
@gitfvb
gitfvb / Convert-XMLtoPSObject.ps1
Created December 3, 2020 11:12
Allow xml to pscustomobject transformation in PowerShell to allow conversion to json, copied from https://github.com/gitfvb/AptecoHelperScripts/blob/master/functions/Xml/Convert-XMLtoPSObject.ps1
<#
.SYNOPSIS
Conversion of valid xml into a PSCustomObject, so it can be easily used to create json instead
.DESCRIPTION
Inspired from the C# example from: Translated into PowerShell from https://dev.to/adamkdean/xml-to-hashtable-59dg
This script uses xml input and converts all tags and attributes into a PSCustomObject.
This allows a much easier transformation into a json object.
.EXAMPLE
# Using this input xml (could also be a file) ...
@gitfvb
gitfvb / Rprofile.site
Created December 3, 2020 11:10
R profile file for including some scripts at startup
# Things you might want to change
# options(papersize="a4")
# options(editor="notepad")
# options(pager="internal")
# set the default help type
# options(help_type="text")
options(help_type="html")
@gitfvb
gitfvb / gist:121f888648f707a0b477d9c8cafc8646
Last active September 10, 2020 16:37
Use OBS for Videorecording of Screen and Webcam

Setup OBS

  • E.g. double your screen resolution like here:

grafik

grafik

grafik

@gitfvb
gitfvb / timer.ps1
Created September 4, 2020 14:26
A timer in PowerShell controlled through a "tick" event instead of a start-sleep. Script can be run standalone out of the box.
<#
Good example inspired from here
https://gist.github.com/SteveGilham/98a39f621cfed70bfa0a
To explore possible events, type in
$timer | gm
#>
@gitfvb
gitfvb / binary_cleverreach.ps1
Created June 22, 2020 08:49
Binary options in powershell
<#
HINTS
# check bitwise: https://ingogegenwarth.wordpress.com/2016/11/17/powershell-and-bit-field-attributes/
#>
# Good example because the cleverreach api checks the details to download bitwise... those are the values
$cleverreachDetails = @{
events = 1
@gitfvb
gitfvb / Get-Unixtime.ps1
Created June 9, 2020 13:29
Huspot outlines in PowerShell
# current unixtimestamp with the optional milliseconds
Function Get-Unixtime {
param(
[Parameter(Mandatory=$false)][switch] $inMilliseconds = $false
,[Parameter(Mandatory=$false)][DateTime] $timestamp = ( Get-Date )
)
$multiplier = 1
@gitfvb
gitfvb / checkBackupsAndSpace.ps1
Created June 8, 2020 09:13
Quick example to check the amount of backups and the current used and free space on all local drives and send that information via smtp
$logfile = "D:\Apteco\Log\backup_manual.log"
# log
"$( [datetime]::Now.ToString("yyyyMMddHHmmss") )`t-------------------------------" >> $logfile
# Get all local drives that are currently used (used space greater than 0) and format the numbers and output as list
$currentSpace = Get-PSDrive -PSProvider FileSystem | where { $_.Used -gt 0 } | Select Root, @{name="Used (GB)";expression={ ($_.Used/1GB).ToString(".00") }}, @{name="Free (GB)";expression={ ($_.Free/1GB).ToString(".00") }} | fl
# check how many backups are in a folder
$backupFolder = "D:\Apteco\Publish\<sysname>\backup\"
@gitfvb
gitfvb / dayByDay.ps1
Last active May 6, 2021 11:57
Calculate a month in textform for a diary through PowerShell
[int]$month = Read-Host -Prompt "Monat" # In Nummern wie 6
[int]$year = Read-Host -Prompt "Jahr" # In Nummer wie 2020
$firstDay = Get-Date -Day 01 -Month $month -Year $year
$firstDayNextMonth = $firstDay.AddMonths(1)
$currentDay = $firstDay
cls