Notification on specific applications?

[s016aq]

We trigger WAU at login with WAU_NotificationLevel=None. But with some (big) applications I would like to pop-up some warning that application X is about to be updated. (to minimize the risk that the user starts the app during upgrade). Maybe even kill the process if started. I was thinking, would it be possible to use a -preinstall.ps1 for this? That maybe creates a notif.xml and triggers the Notify task?

[KnifMelti]

For example Visual Studio?
Probably, I'm free from work over Xmas so I can look at it.

[s016aq]

Actually, we let Windows Update handle VIsual Studio. But for example Rancher Desktop or SQL Management Studio. Den tors 18 dec. 2025 kl 17:45 skrev Göran Axel Johannesson < ***@***.***>:

…

For example Visual Studio? — Reply to this email directly, view it on GitHub <#1102 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/A5HRTKOCMWMC7XW62DX57LD4CLK2BAVCNFSM6AAAAACPOCLWHOVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTKMRZGEZTOMA> . You are receiving this because you authored the thread.Message ID: <Romanitho/Winget-AutoUpdate/repo-discussions/1102/comments/15291370@ github.com>

[KnifMelti]

Installation:

21:40:29 - Start Microsoft.SQLServerManagementStudio.21 processing...
21:40:30 - -> Microsoft.SQLServerManagementStudio.21 exists on Winget Repository.
21:40:31 - Modifications for Microsoft.SQLServerManagementStudio.21 before install are being applied...
21:40:35 - SQL Server Management Studio is not installed yet - skipping pre-install monitoring
21:40:35 - -> Installing Microsoft.SQLServerManagementStudio.21...
21:40:35 - -> Arguments (winget-level): --version 21.5.14
21:40:35 - -> Running: "C:\Program Files\WindowsApps\Microsoft.DesktopAppInstaller_1.27.350.0_x64__8wekyb3d8bbwe\winget.exe" install --id Microsoft.SQLServerManagementStudio.21 -e --accept-package-agreements --accept-source-agreements -s winget --version 21.5.14 -h


  █████▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒  1024 KB / 5.85 MB
  ██████████▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒  2.00 MB / 5.85 MB
  ███████████████▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒  3.00 MB / 5.85 MB
  ████████████████████▒▒▒▒▒▒▒▒▒▒  4.00 MB / 5.85 MB
  █████████████████████████▒▒▒▒▒  5.00 MB / 5.85 MB
  ██████████████████████████████  5.85 MB / 5.85 MB
Found Microsoft SQL Server Management Studio 21 [Microsoft.SQLServerManagementStudio.21] Version 21.5.14
This application is licensed to you by its owner.
Microsoft is not responsible for, nor does it grant any licenses to, third-party packages.
Downloading https://download.visualstudio.microsoft.com/download/pr/c2e2845d-bdff-44fc-ac00-3d488e9f5675/9c65ae0a3cf651fda7feb726431b2737eb45a15023687caa047033cba0f86c09/vs_SSMS.exe



  █▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒   260 KB / 4.25 MB
  ██████████████████████████████  4.25 MB / 4.25 MB
Successfully verified installer hash
Starting package install...

Successfully installed
21:43:53 - -> Microsoft.SQLServerManagementStudio.21 successfully installed.
21:43:53 - Microsoft.SQLServerManagementStudio.21 processing finished!

Updating:

-> Available update : SQL Server Management Studio 21. Current version : 21.5.14. Available version : 21.6.17.
21:45:26 - Updating SQL Server Management Studio 21 from 21.5.14 to 21.6.17...
21:45:26 - ##########   WINGET UPGRADE: Microsoft.SQLServerManagementStudio.21   ##########
21:45:26 - Running pre-install mod for Microsoft.SQLServerManagementStudio.21...
21:45:27 - SQL Server Management Studio is already installed - enabling upgrade monitoring
21:45:27 - SSMS is currently running - closing it before installation...
21:45:27 - Killing SSMS process (PID: 4620)
21:45:33 - Starting SSMS process monitoring during installation...
21:45:34 - SSMS monitoring active for installation period
21:45:34 - -> upgrade


  █████▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒  1024 KB / 5.85 MB
  ██████████▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒  2.00 MB / 5.85 MB
  ███████████████▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒  3.00 MB / 5.85 MB
  ████████████████████▒▒▒▒▒▒▒▒▒▒  4.00 MB / 5.85 MB
  █████████████████████████▒▒▒▒▒  5.00 MB / 5.85 MB
  ██████████████████████████████  5.85 MB / 5.85 MB
Found Microsoft SQL Server Management Studio 21 [Microsoft.SQLServerManagementStudio.21] Version 21.6.17
This application is licensed to you by its owner.
Microsoft is not responsible for, nor does it grant any licenses to, third-party packages.
Downloading https://download.visualstudio.microsoft.com/download/pr/5967a899-96aa-47e2-a7c5-1b7192f292ee/cb58e449b5f554b28fa66a2a04d7c1bf55073f16242c8eb3b4d63fbfc10de5d0/vs_SSMS.exe



  █▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒   260 KB / 4.25 MB
  ██████████████████████████████  4.25 MB / 4.25 MB
Successfully verified installer hash
Starting package install...

Successfully installed
21:46:52 - ##########   FINISHED: Microsoft.SQLServerManagementStudio.21   ##########
21:46:52 - SQL Server Management Studio 21 updated to 21.6.17!
21:46:52 - 1 apps updated ! No more update.

Microsoft.SQLServerManagementStudio.21-preinstall.ps1:

# Load WAU functions
. "$PSScriptRoot\_Mods-Functions.ps1"

# Check if SSMS is already installed using winget
$ssmsInstalled = & $Winget list "SQL Server Management Studio" --accept-source-agreements | Out-String
if ($ssmsInstalled -notmatch "SQL Server Management Studio") {
    Write-ToLog "SQL Server Management Studio is not installed yet - skipping pre-install monitoring"
    return $true
}

Write-ToLog "SQL Server Management Studio is already installed - enabling upgrade monitoring"

# Check if SSMS is already running and kill it
$runningSSMS = Get-Process -Name "Ssms" -ErrorAction SilentlyContinue
if ($runningSSMS) {
    Write-ToLog "SSMS is currently running - closing it before installation..."
    foreach ($proc in $runningSSMS) {
        Write-ToLog "Killing SSMS process (PID: $($proc.Id))"
        Stop-Process -Id $proc.Id -Force -ErrorAction SilentlyContinue
    }
    Start-Sleep -Seconds 2
}

# Create notification XML
[xml]$ToastTemplate = @"
<?xml version="1.0" encoding="utf-8"?>
<toast>
    <visual>
        <binding template="ToastGeneric">
            <image placement="appLogoOverride" src="$WorkingDir\icons\warning.png"/>
            <text>SQL Server Management Studio Update</text>
            <text>Installing SSMS. Do not start SQL Server Management Studio during installation - it will be automatically closed if started!</text>
        </binding>
    </visual>
    <tag>SSMS-PreInstall</tag>
</toast>
"@

# Save and trigger notification
$ToastTemplateLocation = "$WorkingDir\config\"
$ToastTemplate.Save("$ToastTemplateLocation\notif.xml")
Get-ScheduledTask -TaskName "Winget-AutoUpdate-Notify" -ErrorAction SilentlyContinue | Start-ScheduledTask -ErrorAction SilentlyContinue
Start-Sleep -Seconds 2

# Start monitoring immediately in background job
Write-ToLog "Starting SSMS process monitoring during installation..."
$monitoringJob = Start-Job -ScriptBlock {
    param($LogFile, $MonitorDuration)
    
    $endTime = (Get-Date).AddSeconds($MonitorDuration)
    
    while ((Get-Date) -lt $endTime) {
        # Check for SSMS main processes
        $ssmsProcesses = Get-Process -Name "Ssms" -ErrorAction SilentlyContinue
        
        if ($ssmsProcesses) {
            foreach ($proc in $ssmsProcesses) {
                $logMessage = "$(Get-Date -Format 'yyyy-MM-dd HH:mm:ss') - Killing SSMS process (PID: $($proc.Id)) started during installation"
                Add-Content -Path $LogFile -Value $logMessage -Force
                Stop-Process -Id $proc.Id -Force -ErrorAction SilentlyContinue
            }
        }
        
        Start-Sleep -Seconds 2
    }
} -ArgumentList $LogFile, 600  # Monitor for 10 minutes

Write-ToLog "SSMS monitoring active for installation period"

# Return true to let WAU continue with installation
return $true

[KnifMelti]

That's it!
Mr. Claude did it.

[s016aq]

King of Kings! This will be very usefull. Tack!

[KnifMelti]

There's something funny with the background job:

$monitoringJob = Start-Job -ScriptBlock {
    param($LogFile, $MonitorDuration)
    
    $endTime = (Get-Date).AddSeconds($MonitorDuration)
    
    while ((Get-Date) -lt $endTime) {
        # Check for SSMS main processes
        $ssmsProcesses = Get-Process -Name "Ssms" -ErrorAction SilentlyContinue
        
        if ($ssmsProcesses) {
            foreach ($proc in $ssmsProcesses) {
                $logMessage = "$(Get-Date -Format 'yyyy-MM-dd HH:mm:ss') - Killing SSMS process (PID: $($proc.Id)) started during installation"
                Add-Content -Path $LogFile -Value $logMessage -Force
                Stop-Process -Id $proc.Id -Force -ErrorAction SilentlyContinue
            }
        }
        
        Start-Sleep -Seconds 2
    }
} -ArgumentList $LogFile, 600  # Monitor for 10 minutes

But it does the job despite not being written to the $LogFile when starting SSMS; I don't have the stamina...
Det var så lite, glad att jag kunde hjälpa till en smula!

[KnifMelti]

Final version of Microsoft.SQLServerManagementStudio.21-preinstall.ps1 (EDIT: solved file-locking problems):

# Load WAU functions
. "$PSScriptRoot\_Mods-Functions.ps1"

# Check if SSMS is already installed using winget
$ssmsInstalled = & $Winget list "SQL Server Management Studio" --accept-source-agreements | Out-String
if ($ssmsInstalled -notmatch "SQL Server Management Studio") {
    Write-ToLog "SQL Server Management Studio is not installed yet - skipping pre-install monitoring"
    return $true
}

Write-ToLog "SQL Server Management Studio is already installed - enabling upgrade monitoring"

# Check if SSMS is already running and kill it
$runningSSMS = Get-Process -Name "Ssms" -ErrorAction SilentlyContinue
if ($runningSSMS) {
    Write-ToLog "SSMS is currently running - closing it before installation..."
    foreach ($proc in $runningSSMS) {
        Write-ToLog "Killing SSMS process (PID: $($proc.Id))"
        Stop-Process -Id $proc.Id -Force -ErrorAction SilentlyContinue
    }
    Start-Sleep -Seconds 2
}

# Create notification XML
[xml]$ToastTemplate = @"
<?xml version="1.0" encoding="utf-8"?>
<toast>
    <visual>
        <binding template="ToastGeneric">
            <image placement="appLogoOverride" src="$WorkingDir\icons\warning.png"/>
            <text>SQL Server Management Studio Update</text>
            <text>Installing SSMS. Do not start SQL Server Management Studio during installation - it will be automatically closed if started!</text>
        </binding>
    </visual>
    <tag>SSMS-PreInstall</tag>
</toast>
"@

# Save and trigger notification
$ToastTemplateLocation = "$WorkingDir\config\"
$ToastTemplate.Save("$ToastTemplateLocation\notif.xml")
Get-ScheduledTask -TaskName "Winget-AutoUpdate-Notify" -ErrorAction SilentlyContinue | Start-ScheduledTask -ErrorAction SilentlyContinue
Start-Sleep -Seconds 2

# Start monitoring immediately in background job
# Create separate log file for background monitoring job to avoid file-locking issues
$MonitorLogFile = Join-Path $WorkingDir "logs\ssms-monitor.log"
Write-ToLog "Starting SSMS process monitoring during installation..."
$Script:monitoringJob = Start-Job -ScriptBlock {
    param($LogFilePath, $MonitorDuration)

    $endTime = (Get-Date).AddSeconds($MonitorDuration)

    while ((Get-Date) -lt $endTime) {
        # Check for SSMS main processes
        $ssmsProcesses = Get-Process -Name "Ssms" -ErrorAction SilentlyContinue

        if ($ssmsProcesses) {
            foreach ($proc in $ssmsProcesses) {
                $logMessage = "$(Get-Date -Format 'yyyy-MM-dd HH:mm:ss') - Killing SSMS process (PID: $($proc.Id)) started during installation"
                Add-Content -Path $LogFilePath -Value $logMessage -Force
                Stop-Process -Id $proc.Id -Force -ErrorAction SilentlyContinue
            }
        }

        Start-Sleep -Seconds 2
    }
} -ArgumentList $MonitorLogFile, 600  # Monitor for 10 minutes

Write-ToLog "SSMS monitoring active for installation period (10 minutes) - any SSMS process started will be automatically terminated (logged to ssms-monitor.log)"

# Return true to let WAU continue with installation
return $true

[s016aq]

Top notch! Thank you so much.

[KnifMelti]

EDIT: now with file-locking problems solved.