Hans hansgafriedzal

rather be opposed, than misunderstood

hansgafriedzal / MusicBee.md

Last active July 7, 2022 11:04

musicbee snippets

Naming Template

<Album Artist>\$IsNull(<Year>,,$Pad(<Year>,2)" ")<Album>\$IsNull(<Track#>,"",$Pad(<Track#>,2))<Title>

$IsNull(<Track#>,"",$Pad(<Track#>,2) )<Title>

hansgafriedzal / Get-XlsContentDemo.ps1

Created September 20, 2021 04:35

	$path = "https://<tenant>.sharepoint.com/sites/<site>/<library>/<file>.xlsx"
	$worksheetNames = ""
	$save = $true

	$excel = new-object -comobject excel.application

	$timestamp = Get-Date -format "yyyyMMddHHmmss"

	try
	{

hansgafriedzal / yt-dlp.md

Last active August 3, 2022 07:21

yt-dlp 7mMfeFxMC8Y --extract-audio --audio-format mp3 -f bestaudio --add-metadata --xattrs --embed-thumbnail

hansgafriedzal / ffmpeg.md

Last active July 18, 2022 03:29

dir *.mp4 | %{
    ffmpeg -i $_ -f mp3 -ab 320k -vn "$($_.BaseName).mp3"
}

hansgafriedzal / search

Last active March 2, 2024 05:53

	https://gist.github.com/search?q=user%3Ahansgafriedzal+%s
	https://www.youtube.com/results?search_query=%s
	https://proxyrarbg.org/torrents.php?search=rarbg+%s&category[]=54
	https://proxyrarbg.org/torrents.php?search=rartv%+%s
	https://shopee.sg/search?keyword=%s&order=asc&sortBy=price
	https://www.lazada.sg/catalog/?q=%s&sort=priceasc
	{google:baseURL}search?q=site:microsoft.com+%s
	https://www.carousell.sg/categories/electronics-7?search=%s
	http://www.aliexpress.com/wholesale?SearchText=%s&opensearch=true&SortType=price_asc
	{google:baseURL}maps/search/%s

hansgafriedzal / Install-Hyper-V.bat

Created December 20, 2020 15:20 — forked from manciuszz/Install-Hyper-V.bat

Windows 10 Home | Hyper-V Management scripts

	@echo off
	pushd "%~dp0"
	dir /b %SystemRoot%\servicing\Packages\Hyper-V.mum >hyper-v.txt
	for /f %%i in ('findstr /i . hyper-v.txt 2^>nul') do dism /online /norestart /add-package:"%SystemRoot%\servicing\Packages\%%i"
	del hyper-v.txt
	Dism /online /enable-feature /featurename:Microsoft-Hyper-V -All /LimitAccess /ALL

hansgafriedzal / Monitor-Defacement.ps1

Last active November 5, 2020 16:48

	cls
	$url = 'https://www.google.com'
	$retryInterval = 2
	$c = 1

	function Get-Response
	{
	param($url)
	Write-Progress -Activity "attempt number #$c" -Status $url

hansgafriedzal / BulkRemove-AzureADGroupAppRoleAssignment.ps1

Created September 30, 2020 17:21

	<#

	CSV FORMAT

	+------------+--------------+--------------+
	\| Group Name \| Group Owner1 \| Group Owner2 \|
	+------------+--------------+--------------+
	\| group1 \| user@domain \| user@domain \|
	\| group2 \| user@domain \| user@domain \|
	\| group3 \| user@domain \| user@domain \|

hansgafriedzal / BulkNew-AzureADGroupAppRoleAssignment.ps1

Last active October 1, 2020 04:27

	<#

	CSV FORMAT

	+------------+--------------+--------------+
	\| Group Name \| Group Owner1 \| Group Owner2 \|
	+------------+--------------+--------------+
	\| group1 \| user@domain \| user@domain \|
	\| group2 \| user@domain \| user@domain \|
	\| group3 \| user@domain \| user@domain \|

hansgafriedzal / BulkRemove-AzureADGroup.ps1

Last active October 1, 2020 02:28

	<#

	CSV FORMAT

	+------------+--------------+--------------+
	\| Group Name \| Group Owner1 \| Group Owner2 \|
	+------------+--------------+--------------+
	\| group1 \| user@domain \| user@domain \|
	\| group2 \| user@domain \| user@domain \|
	\| group3 \| user@domain \| user@domain \|