Skip to main content

Patching - Windows 10 Build Upgrades

Summary​

This monitor will look for machines that are running below the latest build of Windows and trigger the script to upgrade the machine. We recommend scheduling this monitor daily during off-hours to avoid any loss of user productivity.

Dependencies​

  • Windows 10 Upgrade Assistant

Target​

Global - Should be run without explicitly defined targets.

Translated SQL​

SELECT 
    computers.version AS 'testvalue',
    computers.name AS 'identityfield',
    computers.computerid,
    acd.uptimestart,
    acd.uptimeend,
    acd.noalerts
FROM 
    computers
LEFT JOIN 
    agentcomputerdata acd ON acd.computerid = computers.computerid
WHERE 
    computers.lastcontact > NOW() - INTERVAL 15 MINUTE 
    AND computers.os LIKE '%windows 10%' 
    AND computers.version < '10.0.19044' 
    AND computers.computerid IN (SELECT computerid FROM computerpatchpolicies WHERE installpolicy IN (SELECT ID FROM installsoftwarepolicies WHERE updatemode IN (5, 6)))
LIMIT 10