ConfigMgr SCCM Software Updates Patching WMI Troubleshooting Tips Endpoint Manager. This post will help you perform some of the WMI troubleshooting tips related to Software Updates.
Latest Post – SCCM CMPivot Query Patches Installed In Last 90 Days | ConfigMgr HTMD Blog (anoopcnair.com)
ConfigMgr SCCM Software Updates Patching WMI Troubleshooting Tips Endpoint Manager
ConfigMgr SCCM Software Updates Patching WMI Troubleshooting Tips Endpoint Manager.
- WSUS Server details of a client
- Compliancy detail of a particular update
- Notification Settings of Software Updates – Patch Management
- WSUS Server details of a client
1. Connect to “Root\ccm\softwareupdates\WUAHandler.”
2. Click on “Query” and paste the following query in the “query” windows and click on “Apply.”
select * from CCM_updatesource
3. Double click the one row that is returned (note if there is more than one),
4. Click the “Show MOF” tab on the Object editor window.
5. Review the setting for CCM_UpdateSource for the update we’ve selected. In this example, ContentLocation is set to WSUS Server we scanned against.
Compliancy detail of a particular update
1. Connect to “Root\ccm\softwareupdates\UpdatesStore”
2. Click on “Query” and paste the following query in the “query” windows and click on “Apply.”
select * from CCM_UpdateStatus
3. Double click the one row that is returned (note if there is more than one).
4. Click the “Show MOF” tab on the Object editor window.
5. Review the setting for CCM_UpdateStatus for the update we’ve selected. In this example, STATUS = “Missing.”
Notification Settings of Software Updates – Patch Management
1. Connect to “Root\ccm\policy\machine\ActualConfig”
2. Click on “Query” and paste the following query in the “query” windows and click on “Apply.”
select * from CCM_UpdateCIAssignment
3. Double click the one row that is returned (note if there is more than one).
4. Click the “Show MOF” tab on the Object editor window.
5. Review the setting for CCM_UpdateCIAssignment for the update we’ve selected. In this example NotifyUser = “TRUE“.
Note – You can also check out Reboot and Maintenance Window Settings from the above screenshot.
Author
Anoop is Microsoft MVP! He is a Solution Architect in enterprise client management with more than 20 years of experience (calculation done in 2021) in IT. He is a blogger, Speaker, and Local User Group HTMD Community leader. His main focus is on Device Management technologies like SCCM 2012, Current Branch, and Intune. E writes about ConfigMgr, Windows 11, Windows 10, Azure AD, Microsoft Intune, Windows 365, AVD, etc…
Hi i want to appreciate your excellent page and share your knowledge and expertise
i have an issue because i manage almost 100 computers with missing updates, when i review logs everything is fine, but i get missing updates a group updates deployed to the collection by month
reinstall sccm, repait sccm, fix update, reset wua, but no fix it.
what can you give any idea?
i understand that WMI database record the compliance states.
do i have rebuil wmi?
thanks in advance