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