Skip to content

Instantly share code, notes, and snippets.

Avatar

Fabian Bader f-bader

View GitHub Profile
View SyncExchangeOnPremSendAsPermissions.ps1
<#
This script syncs SendAs permissions from Exchange on-Prem to Exchange Online to avoid a misconfigured hybrid environment
Uses Azure Automation for scheduling and safely storing the on-Prem credentials as well as the authentication certificate for Exchange Online
Prerequisites
* Azure Automation Account
* Hybrid Worker
* Setup App-only authentication (https://docs.microsoft.com/en-us/powershell/exchange/app-only-auth-powershell-v2)
* Install private certificate as exportable to Azure Automation Account as 'Exchange Hybrid Automation'
* Store OnPrem Exchange credentials in Azure Automation Account as 'Exchange onPrem'
@f-bader
f-bader / Test-IsO365IpAddress.ps1
Created Aug 23, 2019
Test if a IP address is part of the Office 365 endpoints
View Test-IsO365IpAddress.ps1
[CmdletBinding()]
param (
# IP Address to check against Office 365 Range
[Parameter(Mandatory = $true,
ValueFromPipeline = $true,
Position = 0)]
$IPAddress,
# Port to check
[Parameter(Mandatory = $false,
@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
You can’t perform that action at this time.