Navigating the Transition from Configuration Manager to Azure Update Manager

				
					<#
    =================================================================================
    DISCLAIMER:
    This script is provided "as-is" with no warranties. Usage of this script is at
    your own risk. The author is not liable for any damages or losses arising from
    using this script. Please review the full legal disclaimer at:
    https://kaidojarvemets.com/legal-disclaimer/
    =================================================================================
#>

function Convert-SCCMDescriptionToRecurEvery {
    param (
        [string]$Description
    )

    # Regex patterns to match various descriptions
    $patterns = @{
        'every 1 days' = { "1Day" }
        'every (\d+) days' = { param($matches) "$($matches[1])Day" } # Handles descriptions like "every 11 days"
        'the last day of every 1 months' = { "1Month day-1" }
        'every (\d+) weeks on (\w+)' = { 
            param($matches) 
            $weekCount = $matches[1]
            $dayOfWeek = $matches[2]
            $interval = if ($weekCount -eq 1) { "1Week $dayOfWeek" } else { "${weekCount}Weeks $dayOfWeek" }
            $interval
        }
        '2 day\(s\) after the Second Tuesday of every 1 months' = { "1Month Second Tuesday Offset2" }
        'every 1 weeks on (\w+)' = { param($matches) "1Week $($matches[1])" }
        'day (\d+) of every 1 months' = { param($matches) "1Month day$($matches[1])" }
        'the (\w+) (\w+) of every (\d+) months' = { param($matches) "1Month $($matches[1]) $($matches[2])" }
    }

    foreach ($pattern in $patterns.Keys) {
        if ($Description -match $pattern) {
            return (& $patterns[$pattern] $matches).Trim()
        }
    }

    return "---------- $Description - Pattern not supported or failed to convert"
}

######################## SCRIPT ENTRY POINT ########################################

# Import Configuration Manager Module
Import-Module $env:SMS_ADMIN_UI_PATH.Replace("\bin\i386", "\bin\configurationmanager.psd1")
$SiteCode = Get-PSDrive -PSProvider CMSITE
Set-Location "$($SiteCode.Name):\"

$SWUpdatesFolderID = 16777224 # Software Updates Device Collection Folder. Use Get-CMFolder to identify the ContainerNodeID
$SiteCode = $SiteCode.Name
$MaintenanceWindows = @()

# Query All Collections from Software Updates Folder
$CollectionsInSpecficFolder = Get-CimInstance -Namespace "ROOT\SMS\Site_$SiteCode" `
-Query "SELECT * FROM SMS_Collection WHERE CollectionID IN (SELECT InstanceKey FROM SMS_ObjectContainerItem WHERE ObjectType='5000' AND ContainerNodeID='$SWUpdatesFolderID') AND CollectionType='2'"

Write-Output -InputObject "Device Collections in $SWUpdatesFolderID folder: $($CollectionsInSpecficFolder.Count)"

foreach ($Collection in $CollectionsInSpecficFolder) {
    $MWQuery = Get-CMMaintenanceWindow -CollectionId $Collection.CollectionID
    
    foreach ($MW in $MWQuery) {
        $AzureRecurEvery = Convert-SCCMDescriptionToRecurEvery -Description $MW.Description
        
        $DurationExceeds = if ($MW.Duration -gt 235) { "YES" } else { "NO" }

        $MaintenanceWindowProps = [ORDERED]@{
            Collection = $Collection.Name
            CollectionID = $Collection.CollectionID
            MWName = $MW.Name
            IsEnabled = $MW.IsEnabled
            IsGMT = $MW.IsGMT
            ServiceWindowType = switch ($MW.ServiceWindowType) {1 {'All Deployments'} 4 {'Software Updates'} 5 {'Task Sequences'}}
            StartTime = $MW.StartTime
            Description = $MW.Description
            AzureRecurEvery = $azureRecurEvery
            Duration = $MW.Duration
            DurationExceedsAzureLimit = $durationExceeds
        }
        $MaintenanceWindows += New-Object PSObject -Property $MaintenanceWindowProps
    }
}
$MaintenanceWindows | Out-GridView