ConfigMgr SCCM Software Updates Patching WMI Troubleshooting Tips Endpoint Manager

Let’s discuss ConfigMgr SCCM Software Updates Patching WMI Troubleshooting Tips Endpoint Manager.

This post will help you perform some WMI troubleshooting tips related to Software Updates.

WMI is Windows Management Instrumentation. The WMI is the Microsoft implementation of Web-Based Enterprise Management (WBEM).

Configuration Manager admins need to know more about WMI Explorer. SCCM can fetch the details from any available WMI classes. The WMI namespaces and classes can be custom classes for custom hardware inventory.

Patch My PC
Index
ConfigMgr SCCM Software Updates Patching WMI Troubleshooting Tips
ConfigMgr SCCM Software Updates Patching WMI Troubleshooting Tips Endpoint Manager – Table 1

ConfigMgr SCCM Software Updates Patching WMI Troubleshooting Tips

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

ConfigMgr SCCM Software Updates Patching WMI Troubleshooting Tips Endpoint Manager - Fig.1
ConfigMgr SCCM Software Updates Patching WMI Troubleshooting Tips Endpoint Manager – Fig.1

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

Adaptiva

select * from CCM_updatesource

ConfigMgr SCCM Software Updates Patching WMI Troubleshooting Tips Endpoint Manager - Fig.2
ConfigMgr SCCM Software Updates Patching WMI Troubleshooting Tips Endpoint Manager – Fig.2

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

ConfigMgr SCCM Software Updates Patching WMI Troubleshooting Tips Endpoint Manager - Fig.3
ConfigMgr SCCM Software Updates Patching WMI Troubleshooting Tips Endpoint Manager – Fig.3

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

ConfigMgr SCCM Software Updates Patching WMI Troubleshooting Tips Endpoint Manager - Fig.4
ConfigMgr SCCM Software Updates Patching WMI Troubleshooting Tips Endpoint Manager – Fig.4

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.

ConfigMgr SCCM Software Updates Patching WMI Troubleshooting Tips Endpoint Manager - Fig.5
ConfigMgr SCCM Software Updates Patching WMI Troubleshooting Tips Endpoint Manager – Fig.5

Compliancy detail of a particular update

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

ConfigMgr SCCM Software Updates Patching WMI Troubleshooting Tips Endpoint Manager - Fig.6
ConfigMgr SCCM Software Updates Patching WMI Troubleshooting Tips Endpoint Manager – Fig.6

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

select * from CCM_UpdateStatus

ConfigMgr SCCM Software Updates Patching WMI Troubleshooting Tips Endpoint Manager - Fig.7
ConfigMgr SCCM Software Updates Patching WMI Troubleshooting Tips Endpoint Manager – Fig.7

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

Software Updates Patching WMI Troubleshooting

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

ConfigMgr SCCM Software Updates Patching WMI Troubleshooting Tips Endpoint Manager - Fig.8
ConfigMgr SCCM Software Updates Patching WMI Troubleshooting Tips Endpoint Manager – Fig.8

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

ConfigMgr SCCM Software Updates Patching WMI Troubleshooting Tips Endpoint Manager - Fig.9
ConfigMgr SCCM Software Updates Patching WMI Troubleshooting Tips Endpoint Manager – Fig.9

Notification Settings of Software Updates – Patch Management

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

ConfigMgr SCCM Software Updates Patching WMI Troubleshooting Tips Endpoint Manager - Fig.10
ConfigMgr SCCM Software Updates Patching WMI Troubleshooting Tips Endpoint Manager – Fig.10

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

select * from CCM_UpdateCIAssignment

ConfigMgr SCCM Software Updates Patching WMI Troubleshooting Tips Endpoint Manager - Fig.11
ConfigMgr SCCM Software Updates Patching WMI Troubleshooting Tips Endpoint Manager – Fig.11

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

ConfigMgr SCCM Software Updates Patching WMI Troubleshooting Tips Endpoint Manager - Fig.12
ConfigMgr SCCM Software Updates Patching WMI Troubleshooting Tips Endpoint Manager – Fig.12

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

ConfigMgr SCCM Software Updates Patching WMI Troubleshooting Tips Endpoint Manager - Fig.13
ConfigMgr SCCM Software Updates Patching WMI Troubleshooting Tips Endpoint Manager – Fig.13

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

ConfigMgr SCCM Software Updates Patching WMI Troubleshooting Tips Endpoint Manager - Fig.14
ConfigMgr SCCM Software Updates Patching WMI Troubleshooting Tips Endpoint Manager – Fig.14

Note – You can also check out Reboot and Maintenance Window Settings from the above screenshot.

We are on WhatsApp. To get the latest step-by-step guides and news updates, Join our Channel. Click here –HTMD WhatsApp.

Author

Anoop C Nair has been Microsoft MVP from 2015 onwards for 10 consecutive years! He is a Workplace Solution Architect with more than 22+ years of experience in Workplace technologies. He is also a Blogger, Speaker, and leader of the Local User Group Community. His main focus is on Device Management technologies like SCCM and Intune. He writes about technologies like Intune, SCCM, Windows, Cloud PC, Windows, Entra, Microsoft Security, Career, 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.