How to check WUA version on clients
I found this article How to Check the Windows Update Agent Version on Clients (http://technet.microsoft.com/en-us/library/bb680319.aspx) that provides a SQL query that should return WUA version on the client. The query in the article is:
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
I ran this query in my site and only about 6500 of my 32500+ clients are reporting this version data.In the article it says that "The WUA version is not recorded until a client computer scans for software updates compliance at least one time and then hardware inventory is collected for the client computer" but we have Software Updates enabled on our sites and all PCs are doing scans/evals and hardware inventories regularly, so I don't understand why this data does not exist in the database. My own PC does not return this data and I know that my scans and inventories are indeed working correctly.
Can someone help me understand where to start looking to find out why this data does not exist for most of my client base?
Thanks! --Jo
All Replies
- The query returns all computers in my environment. What if you leave out there where statement what does it return?
John Marcum | http://www.TrueSec.com/en/Training.htm | http://myitforum.com/cs2/blogs/jmarcum - We checked WMI on the PCs that are not reporting the data and the data is not in the WMI class on the local PC... thus not in the database. Does anyone know how/when that WMI data is updated on the local client?
To verify the WUA version using a software updates report
-
In the Configuration Manager console, navigate to System Center Configuration Manager / Site Database / Computer Management / Reporting / Reports .
-
Right-click Scan 1 - Last scan states by collection or Scan 2 - Last scan states by site , and then click Run .
-
Enter the required parameters, and then click Display .
-
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.
-
Hi Eric,
Yes - these reports use the same data as outlined above in the SQL queries. Thanks.
My problem was that the data from the view (and from the tables) did not exist in the first place and thus the reports/queries could not be used reliably. I opened a case with Microsoft and we tracked some of my PCs. Here's what I found:When a scan cycle was executed once every 2 days, the data was placed in WMI on the PC.
Subsequent hardware inventories would report that data to the database correctly.
SMS_DEF.MOF would get recompiled on the PC.
Data would be removed from WMI.
Subsequent hardware inventories would remove that data from the database.
I created my own problem to some extent. I know that my own custom namespace creation should be in the configuration mof with only the reporting elements in the sms_def.mof, but I haven't yet redesigned my MOF files to take advantage of the configuration mof. Instead, I make sure that every client recompiles the sms_def.mof on a regular basis to get any new namespaces created for custom data collection from registry keys, etc. In the sms_def.mof, under the Win32_WindowsUpdateAgentVersion section, there was a "pragma delete namespace" command that was being executed every time the mof was compiled, which was removing the wua version data from WMI on the machines when they would compile the MOF.
I removed that delete namespace command from the sms_def.mof and now the data in WMI is not removed and inventory data correctly contains the win32_windowsupdateversion data as it should.
--Jo
