ConfigMgr SCCM Software Updates Patching WMI Troubleshooting Tips Endpoint Manager

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.”

Patch My PC
Software Updates Patching WMI Troubleshooting

2. Click on “Query” and paste the following query in the “query” windows and click on “Apply.”

select * from CCM_updatesource

image
ConfigMgr SCCM Software Updates Patching WMI Troubleshooting Tips Endpoint Manager

3. Double click the one row that is returned (note if there is more than one),

image
ConfigMgr SCCM Software Updates Patching WMI Troubleshooting Tips Endpoint Manager

4. Click the “Show MOF” tab on the Object editor window.

image
ConfigMgr SCCM Software Updates Patching WMI Troubleshooting Tips Endpoint Manager

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.

Software Updates Patching WMI Troubleshooting
ConfigMgr SCCM Software Updates Patching WMI Troubleshooting Tips Endpoint Manager

Compliancy detail of a particular update

1. Connect to “Root\ccm\softwareupdates\UpdatesStore”

image
ConfigMgr SCCM Software Updates Patching WMI Troubleshooting Tips Endpoint Manager

2. Click on “Query” and paste the following query in the “query” windows and click on “Apply.”

select * from CCM_UpdateStatus

Software Updates Patching WMI Troubleshooting

3. Double click the one row that is returned (note if there is more than one).

Software Updates Patching WMI Troubleshooting

4. Click the “Show MOF” tab on the Object editor window.

image

5. Review the setting for CCM_UpdateStatus for the update we’ve selected. In this example, STATUS = “Missing.”

image

Notification Settings of Software Updates – Patch Management

1. Connect to “Root\ccm\policy\machine\ActualConfig”

image

2. Click on “Query” and paste the following query in the “query” windows and click on “Apply.”

select * from CCM_UpdateCIAssignment

image

3. Double click the one row that is returned (note if there is more than one).

image

4. Click the “Show MOF” tab on the Object editor window.

image

5. Review the setting for CCM_UpdateCIAssignment for the update we’ve selected. In this example NotifyUser = “TRUE“.

image

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…

1 thought on “ConfigMgr SCCM Software Updates Patching WMI Troubleshooting Tips Endpoint Manager”

  1. 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

    Reply

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.