To display the WUA version on client computers using a SQL query

  • Create a query statement that retrieves client computers and the Windows Update Agent version, such as the following sample query statement:
SELECT v_R_System.Netbios_Name0, v_GS_WINDOWSUPDATEAGENTVERSIO.Version0 FROM v_GS_WINDOWSUPDATEAGENTVERSIO INNER JOIN v_R_System ON v_GS_WINDOWSUPDATEAGENTVERSIO.ResourceID = v_R_System.ResourceID WHERE v_GS_WINDOWSUPDATEAGENTVERSIO.Version0 <> 'ISNULL' ORDER BY v_GS_WINDOWSUPDATEAGENTVERSIO.Version0

To verify the WUA version using a software updates report

  1. In the Configuration Manager console, navigate to System Center Configuration Manager / Site Database / Computer Management / Reporting / Reports.
  2. Right-click Scan 1 - Last scan states by collection or Scan 2 - Last scan states by site, and then click Run.
  3. Enter the required parameters, and then click Display.
  4. Click the drill-down link in the left column for one of the scan states. The WUA version is displayed in the Windows Update Agent Version column for all client computers for the specific scan state.

To verify the WUA version using Resource Explorer

  1. In the Configuration Manager console, navigate to System Center Configuration Manager / Site Database / Computer Management / Collections.
  2. Click the collection that contains the client computer.
  3. Right-click the client computer, click Start, and then click Resource Explorer.
  4. Expand Hardware, and then click Windows Update Agent Version.
 

Leave a Reply