SvenAelterman

{
  "version": "Notebook/1.0",
  "items": [
    {
      "type": 9,
      "content": {
        "version": "KqlParameterItem/1.0",
        "crossComponentResources": ["{Workspaces}"],
        "parameters": [
          {

SvenAelterman

<#
#>
function Get-ConfigSet()
{
	return Get-WmiObject –namespace "root\Microsoft\SqlServer\ReportServer\RS_SSRS\v14\Admin" `
		-class MSReportServer_ConfigurationSetting -ComputerName localhost
}

# Allow importing of sqlps module
Set-ExecutionPolicy -ExecutionPolicy RemoteSigned -Force

SvenAelterman

{
	"$schema": "https://raw.githubusercontent.com/JanDeDobbeleer/oh-my-posh/main/themes/schema.json",
	"blocks": [
		{
			"alignment": "left",
			"segments": [
				{
					"background": "p:user_host-back",
					"foreground": "p:white",
					"leading_diamond": "",

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

# Parameters
[CmdletBinding(SupportsShouldProcess)]
param (
    [Parameter(Mandatory = $true)]
    [string] $ResourceGroupName,
    [Parameter()]
    [string] $OsName = "linux"
)

# Get all Azure Arc enabled servers in the resource group

SvenAelterman

# A PowerShell script using the Az PowerShell module to remove a specific extension WindowsPatchExtension from all Azure Arc enabled machines in a specific resource group.
# The script will remove the extension from all machines in the resource group, regardless of the extension status.

# Parameters
[CmdletBinding()]
param (
    [Parameter(Mandatory = $true)]
    [string] $ResourceGroupName,
    [Parameter()]
    [string] $ExtensionName = "WindowsPatchExtension"

SvenAelterman

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

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

SvenAelterman

[CmdletBinding()]
param (
    [Parameter(Mandatory)]
    [string]$TargetSubscriptionId,
    [Parameter(Mandatory)]
    [string]$TargetResourceGroup,
    [Parameter(Mandatory)]
    [string]$DeploymentLocation
)

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

$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] }