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’…

Show Windows Update Agent versions

This SQL query will count all WUA versions grouping by Server/Workstation platforms and WUA versions. WUA is the Windows Update Agent responsible for applying software updates on Windows systems. SELECT ‘Workstation’ as ‘Platform’, WUAV.Version0 as ‘Version’, count(sys.Netbios_Name0) as ‘Count’ FROM v_GS_WINDOWSUPDATEAGENTVERSION WUAV JOIN v_R_System Sys ON WUAV.ResourceID = Sys.ResourceID join v_GS_SYSTEM S on S.ResourceID=WUAV.ResourceID WHERE WUAV.Version0…