Count Windows Update Agent versions

The following SQL query counts the Windows Update Agent (WUA) versions by workstations and servers. The WUA is updated via Windows Updates and is the component on Windows systems that applies and reports compliances for patches. /*  Count Windows Update Agents by Platform and WUA versions */ SELECT ‘Workstation’ as ‘Platform’, WUAV.Version0 as ‘Version’, count(*) as ‘Count’…