Share via

ConfigMgr (SCCM) – Software Updates Related WMI Checks

  • Article

To check the WSUS Server we scanned against

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

http://anoopmannur.files.wordpress.com/2011/11/image_thumb10.png?w=244&h=69

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

select * from CCM_updatesource

http://anoopmannur.files.wordpress.com/2011/11/image_thumb11.png?w=244&h=78

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

http://anoopmannur.files.wordpress.com/2011/11/image_thumb12.png?w=244&h=63

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

http://anoopmannur.files.wordpress.com/2011/11/image_thumb13.png?w=244&h=92

5. Review the setting for CCM_UpdateSource for the update that we’ve selected. In this example ContentLocation is set to WSUS Server we scanned against.

http://anoopmannur.files.wordpress.com/2011/11/image_thumb14.png?w=244&h=120

To know the compliancy detail of a particular update

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

http://anoopmannur.files.wordpress.com/2011/11/image_thumb15.png?w=244&h=62

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

select * from CCM_UpdateStatus

http://anoopmannur.files.wordpress.com/2011/11/image_thumb16.png?w=244&h=115

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

http://anoopmannur.files.wordpress.com/2011/11/image_thumb17.png?w=244&h=83

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

http://anoopmannur.files.wordpress.com/2011/11/image_thumb18.png?w=244&h=93

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

http://anoopmannur.files.wordpress.com/2011/11/image_thumb19.png?w=244&h=102

To Check the Notification Settings of Software Updates – Patch Management

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

http://anoopmannur.files.wordpress.com/2011/11/image_thumb20.png?w=244&h=52

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

select * from CCM_UpdateCIAssignment

http://anoopmannur.files.wordpress.com/2011/11/image_thumb21.png?w=244&h=114

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

http://anoopmannur.files.wordpress.com/2011/11/image_thumb22.png?w=244&h=91

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

http://anoopmannur.files.wordpress.com/2011/11/image_thumb23.png?w=244&h=92

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

http://anoopmannur.files.wordpress.com/2011/11/image_thumb24.png?w=244&h=111

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