Skip to content

Instantly share code, notes, and snippets.

Fabian Bader f-bader

View GitHub Profile
@f-bader
f-bader / ARMClient.exe.config
Last active Jul 30, 2018
Proxy, proxy on the wall
View ARMClient.exe.config
<configuration>
<system.net>
<defaultProxy>
<proxy usesystemdefault="false" autoDetect="false" proxyaddress="http://myproxy.local.bader.cloud:3128" bypassonlocal="true"/>
<bypasslist>
<add address="[a-z]+\.local\.bader\.cloud$" />
</bypasslist>
</defaultProxy>
</system.net>
</configuration>
@f-bader
f-bader / Enable-OpenSSHServer.ps1
Created May 3, 2018
OpenSSH Server auf Windows 1709+ aktivieren
View Enable-OpenSSHServer.ps1
# OpenSSH Server installieren
Add-WindowsCapability -Online -Name OpenSSH.Server~~~~0.0.1.0
# Dienst starten
Start-Service sshd
# Starttyp auf "Automatisch" stellen
Set-Service sshd -StartupType Automatic
Set-Service ssh-agent -StartupType Automatic
View gist:fbfb731cc9b6b22119fe6cfdcdcf88ca
USE [DATENBANK]
SELECT
[UserName] = CASE princ.[type]
WHEN 'S' THEN princ.[name]
WHEN 'U' THEN ulogin.[name] COLLATE Latin1_General_CI_AI
END,
[UserType] = CASE princ.[type]
WHEN 'S' THEN 'SQL User'
WHEN 'U' THEN 'Windows User'
END,
@f-bader
f-bader / InviteAzureUser.ps1
Created Jan 29, 2018
Create invite URL for Azure B2B
View InviteAzureUser.ps1
# Use Azure AD Username
$User = "AzureUsername"
$TargetTenant = "TargetTenant"
# Login
$Cred = Get-Credential
Connect-AzureAD -Credential $cred
# Generate Invitation, but do not send
$Invitation = New-AzureADMSInvitation -InvitedUserEmailAddress $User -InvitedUserDisplayName $User -InviteRedirectUrl "https://portal.azure.com/$($TargetTenant)" -SendInvitationMessage $false
# Copy redeem URL to clipboard
$Invitation | Select-Object –ExpandProperty InviteRedeemUrl | clip
@f-bader
f-bader / Get-MyAzureRmAutomationHybridWorkerGroup.ps1
Created Jan 29, 2018
Select all Hybrid Workers within the same Hybrid Worker Group as the current computer
View Get-MyAzureRmAutomationHybridWorkerGroup.ps1
$ComputerSystem = (Get-CimInstance Win32_ComputerSystem)
$FqDn = "$($ComputerSystem.Name).$($ComputerSystem.Domain)"
$HybridWorkerGroup = Get-AzureRmAutomationAccount | Get-AzureRMAutomationHybridWorkerGroup | Where-Object { $FqDn -in $_.RunbookWorker.Name }
$HybridWorkerGroup.RunbookWorker.Name
View ConvertFrom-Xml.ps1
function ConvertFrom-Xml {
<#
.SYNOPSIS
Converts XML object to PSObject representation for further ConvertTo-Json transformation
.EXAMPLE
# JSON->XML
$xml = ConvertTo-Xml (get-content 1.json | ConvertFrom-Json) -Depth 4 -NoTypeInformation -as String
.EXAMPLE
# XML->JSON
ConvertFrom-Xml ([xml]($xml)).Objects.Object | ConvertTo-Json
View TempDisableADSyncExportDeletionThreshold.ps1
Import-Module ADSync
# Your AAD Credentials
$Credential = Get-Credential
# Disable the deletion threshold
Disable-ADSyncExportDeletionThreshold -AADCredential $Credential
# Sync changes
Start-ADSyncSyncCycle -PolicyType Delta
# Enable deletion threshold with default value of 500
Enable-ADSyncExportDeletionThreshold -AADCredential $Credential -DeletionThreshold 500
@f-bader
f-bader / ClearKerberosComputerTicketsAndCertutilCache.ps1
Created Dec 5, 2017
Clear Computer Kerberos tickets and certutil cache
View ClearKerberosComputerTicketsAndCertutilCache.ps1
# Clear Computer Kerberos tickets
klist -li 0x3e7 purge | Out-Null
# Clear certutil cache
certutil -f -policyserver * -policycache delete | Out-Null
@f-bader
f-bader / TFSIdentSyncHistory.sql
Created Nov 9, 2017
Query TFS Identity Synchronization job history
View TFSIdentSyncHistory.sql
SELECT
[QueueTime],
[StartTime],
[EndTime],
[Result],
[QueuedReasons] = CASE jobHist.[QueuedReasons]
WHEN 1 THEN N'Scheduled'
WHEN 2 THEN N'Manual'
ELSE 'Unknown'
END,
@f-bader
f-bader / Sync-TfsIdentity.ps1
Last active Apr 16, 2019 — forked from jstangroome/Sync-TfsIdentity.ps1
Force TFS 2018 to synchronize Active Directory group memberships
View Sync-TfsIdentity.ps1
[CmdletBinding()]
param (
[Parameter(Mandatory=$true, Position=0)]
[uri]
$ServerUri
)
$ErrorActionPreference = 'Stop'
Set-StrictMode -Version Latest
You can’t perform that action at this time.