nicolonsky

// Paste into your favorite KQL engine such as Log Analytics / Sentinel / Defender / ADX
// https://aka.ms/kustofree
let AbsenceInfo = datatable 
    (
    StartDate: datetime,
    EndDate: datetime,
    ActivityDisplayName: string,
    AdditionalDetails: dynamic
)[
    '2025-12-24', '2026-01-04', 'OOO - festive season', dynamic(["Dear colleague,  I'm out of office for christmas holiday season and will take care of your request once I'm back.", "In urgent cases, find my mobile number in teams.", "Merry Christmas & looking forward to seeing you soon.", "🎄❄️🎁", "// Nicola"])

nicolonsky

# See Microsoft 365 Apps Version history https://learn.microsoft.com/en-us/officeupdates/update-history-microsoft365-apps-by-date#version-history

$targetVersions = @{
    'CurrentChannel'                        = [System.Version]::Parse('16.0.16130.20306')
    'MonthlyEnterpriseChannel1'             = [System.Version]::Parse('16.0.16026.20238')
    'MonthlyEnterpriseChannel2'             = [System.Version]::Parse('16.0.15928.20298')
    'Semi-AnnualEnterpriseChannel(Preview)' = [System.Version]::Parse('16.0.16130.20306')
    'Semi-AnnualEnterpriseChannel1'         = [System.Version]::Parse('16.0.15601.20578')
    'Semi-AnnualEnterpriseChannel2'         = [System.Version]::Parse('16.0.14931.20944')
    'CurrentChannel(Preview)'               = [System.Version]::Parse('16.0.16227.20094')

nicolonsky

name: Sign PowerShell Scripts
on:
  push

env:
  ARTIFACT_NAME: PowerShell.Workflows.ScriptSigning

jobs:
  sign_scripts:
    name: Sign and publish PowerShell scripts as pipeline artifacts

nicolonsky

Get-Service LxssManager | Restart-Service

nicolonsky

#Binary search algorithm with O(logn) complexity written in PowerShell

function Invoke-BinarySearch {
    [CmdletBinding()]
    [OutputType([int])]
    param (
        # Array which contains value to search, needs to be sorted
        [Parameter(Mandatory)]
        [int[]]
        $Numbers,

nicolonsky

Start-MpScan -ScanType QuickScan

nicolonsky

# Configure remediation threshold, e.g. 1 day
# Diduct this value from current datetime
$thresholdDateTime = (Get-Date).AddDays(-1)

# Get defender eventlog entries which indicate successful scan
$mostRecentScan = Get-WinEvent -LogName "Microsoft-Windows-Windows Defender/Operational" | Where-Object { $_.ID -in @(1001) } | Select-Object -First 1

if ($mostRecentScan.TimeCreated -lt $thresholdDateTime) {
    Write-Warning "No Microsoft Defender Antivirus scan has been completed sine `"$thresholdDateTime`""
    Exit 1

nicolonsky

$displayName = "Microsoft Graph PowerShell Client Credentials"
$notAfter = $(Get-Date).AddYears(1)
$cert = New-SelfSignedCertificate -CertStoreLocation cert:\currentuser\my -DnsName graph.microsoft.com -Provider "Microsoft Enhanced RSA and AES Cryptographic Provider" -NotAfter $notAfter -FriendlyName $displayName
$export = Export-Certificate -Cert "cert:\currentuser\my\$($cert.Thumbprint)" -FilePath "c:\temp\$displayName.cer"
Write-Output "Exported certificate '$($cert.Thumbprint)' to '$($export.FullName)'"

nicolonsky

function Test-Guid
{
    <#
    .SYNOPSIS
    Validates a given input string and checks string is a valid GUID
    .DESCRIPTION
    Validates a given input string and checks string is a valid GUID by using the .NET method Guid.TryParse
    .EXAMPLE
    Test-Guid -InputObject "3363e9e1-00d8-45a1-9c0c-b93ee03f8c13"
    .NOTES

nicolonsky

# Check Azure AD Access token
if ($null -eq [Microsoft.Open.Azure.AD.CommonLibrary.AzureSession]::AccessTokens){
    Connect-AzureAD
} else {
    $token = [Microsoft.Open.Azure.AD.CommonLibrary.AzureSession]::AccessTokens
    Write-Verbose "Connected to tenant: $($token.AccessToken.TenantId) with user: $($token.AccessToken.UserId)"
}