SvenAelterman

let startTime = ago(30d);
WVDConnections
| where TimeGenerated > startTime
| summarize min(TimeGenerated), max(TimeGenerated) by UserName, ClientOS, ClientType, ClientVersion
| sort by UserName, min_TimeGenerated

SvenAelterman

{
	"$schema": "https://raw.githubusercontent.com/JanDeDobbeleer/oh-my-posh/main/themes/schema.json",
	"blocks": [
		{
			"alignment": "left",
			"segments": [
				{
					"background": "#0077c2",
					"foreground": "#ffffff",
					"leading_diamond": "",

SvenAelterman

[CmdletBinding(SupportsShouldProcess = $True)]
Param(
	[Parameter(Mandatory, Position = 1)]
	[string]$ModuleName
)

$Latest = Get-InstalledModule $ModuleName -ErrorAction Ignore;

# If this module is installed at all
if ($Latest) {

SvenAelterman

$deleteUnattachedNICs = $false

# List all unattached NICs
$unattachedNICs = Get-AzNetworkInterface | `
	Where-Object { $_.VirtualMachine -eq $null -and ($_.PrivateEndpointText -eq $null -or $_.PrivateEndpointText -eq 'null') }

# Iterate over the unattached NICs
foreach ($nic in $unattachedNICs) {
	# Find a lock for the NIC (or resource group/subscription/...)
	$lock = Get-AzResourceLock -ResourceName $nic.Name -ResourceGroupName $nic.ResourceGroupName -ResourceType 'Microsoft.Network/networkInterfaces'

SvenAelterman

# Adapted from http://sharepointjack.com/2017/powershell-script-to-remove-duplicate-old-modules/
Write-Host "This will remove all old versions of installed modules."
Write-Host "Be sure to run this as an admin if modules are installed machine-wide." -ForegroundColor Yellow
Write-Host "(You can update all your Az modules with 'Update-Module Az -Force')."

# This will retrieve all the latest versions of installed modules
$mods = Get-InstalledModule

# Loop through all installed modules
foreach ($Mod in $mods) {

SvenAelterman

# From https://aztoso.com/security/microsoft-graph-permissions-managed-identity/
# Your tenant id (in Azure Portal, under Azure Active Directory -> Overview )
$TenantID = ""
# Microsoft Graph App ID (DON'T CHANGE)
$GraphAppId = "00000003-0000-0000-c000-000000000000"
# Name of the system managed identity (same as the Logic App name)
$DisplayNameOfMSI = "demoLogicApp"
# Check the Microsoft Graph documentation for the permission you need for the operation
$PermissionName = "Domain.Read.All"

SvenAelterman

$contents = "Virtual"
$sql = "SELECT System.ItemName, System.ItemUrl FROM SYSTEMINDEX WHERE Contains(*,'$($contents)') AND System.ItemType='.VSSX'"
$Provider = "Provider=Search.CollatorDSO;Extended Properties=’Application=Windows’;"
$adapter = new-object system.data.oledb.oleDBDataadapter -argument $sql, $Provider

$ds = new-object system.data.dataset

if ($adapter.Fill($ds)) { $ds.Tables[0] }

SvenAelterman

#!/usr/bin/python3
# Simple Python script designed to write to the local Syslog file in CEF format on an Azure Ubuntu 18.04 VM.
# Frank Cardinale, April 2020
# Sven Aelterman, September 2021

# Importing the libraries used in the script
import random
import syslog
import time

SvenAelterman

Import-Module FailoverClusters

[int]$ClusterProbePort = 58888 # The probe port from the WSFCEndPointprobe in the Azure portal. This port must be different from the probe port for the availability group listener probe port.

# Retrieve info from the cluster
$ClusterNetworkName = (Get-ClusterNetwork).Name
$IPResource = (Get-ClusterResource | Where {($_.OwnerGroup -eq "Cluster Group" -And $_.ResourceType -eq "IP Address")})
$IPResourceName = $IPResource.Name

$ClusterCoreIP = ($IPResource | Get-ClusterParameter | Where { $_.Name -eq "Address" }).Value

SvenAelterman

<#
Written with version 2.8.0 of the Azure PowerShell Module 
available from here https://github.com/Azure/azure-powershell/releases/tag/v2.8.0-October2019
or run: Install-Module -Name Az -RequiredVersion 2.6.0 -AllowClobber
Migration instructions Azure.RM to Az - https://azure.microsoft.com/en-au/blog/how-to-migrate-from-azurerm-to-az-in-azure-powershell/
#>

# from https://poshtools.com/2018/04/10/cross-platform-out-gridview-using-universal-dashboard/
function Out-GridView 
{