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…

Disable Help Sticker Notifications

Version: Windows 8.1 Enterprise Upon logging into Windows 8.1 for the first time, a series of Help Sticker Notifications will appear to guide users with the new UI. This may be an unwanted setting if you’re trying to build a reference image. Below is a registry setting that can be added to a registry (*.reg) file…

Install Domain Controller on Windows Server 2012 R2

This post provides an overview to install a new domain controller on Windows Server 2012 R2. Please follow the pre-steps before beginning. Pre-Steps: Administrator account should have a strong password. Windows has been fully patched with software updates. Rename your server to a permanent name. When you install Windows Server, a random name is assigned. Assign…