Configuring SCCM to Report Windows Update Information

If you are using System Center Configuration Manager (SCCM) to push Windows updates pulled from Windows Server Update Services (WSUS), make sure you DO NOT configure the Specify Intranet MS Update Location (GPO).

You will know Windows updates are being pulled by looking here in SCCM:

You want to make sure that the Windows updates have the following results:

•

“Yes” is displayed in the Download column.

•

“Yes” is displayed in the Deployed column.

•

The pie chart shows that some machines require the Windows update.

To verify the SCCM database has the Windows updates you need, run this query:

SELECT v_Update_ComplianceStatusAll.ResourceID, Client_Version0, Distinguished_Name0, Name0, Netbios_Name0, BulletinID, ArticleID, Title

FROM v_r_system

inner join v_Update_ComplianceStatusAll ON v_Update_ComplianceStatusAll.ResourceID=v_r_system.resourceid

inner join v_UpdateInfo ON v_UpdateInfo.CI_ID=v_Update_ComplianceStatusAll.CI_ID

AND v_Update_ComplianceStatusAll.Status IN (2, 3)

You should then get the following result: