mrwyss-msft/showupdateapplicabilityrule

Powershell Script and SCCM Console Extension to see the Applicability Rules of a given Update

Show Update Applicability Rule

Introduction

Windows Updates have Applicability Rules, that decide whether an update is installable or is installed. This information can be very useful in Troubleshooting cases and to understand why a updates report back installed or why a updates is not installing. These Rules are defined in the Update.xml per Update. The Update.xml is stored in the WSUS Update Database in the RootElementXmlCompressed filed of the table tbxml. An update can be bundled. Therefore the bundled update xml needs to be looked at. Show-ApplicabilityRule.ps1 will help you to extract the Applicability Rule.

Script Stand alone

.\Show-ApplicabilityRule.ps1 -SQLServer sql1.ifish.local -SQLDBName SUSDB -UpdateSearchString "%Office 365 Client Update - First Release for Current Channel Version 1706 for x64 based Edition (Build 8229.2056)%"

SCCM Console Extension installation

download the two powershell script and run

./Install-Extension.ps1

Restart the Console

SCCM Console Extension uninstallation

./Install-Extension.ps1 -Uninstall

TODO

• replace temp file workaround in powershell script
• Test in Multi SUS Environment
• Autdetection of SUS SQL and DB
• uninstallation routine script
• Test with WID (Windows Internal Database)
• Better view of the Applicability Rule
• SQL Command Error Handling

Contribute

Let me know, create issues or PR's

showupdateapplicabilityrule's Issues

Nothing inside IsInstalled and IsInstallable

Hi! Love what you've written, it sounds super promising and helpful. I'm just having a little hard time getting my head around it, it's likely I'm doing it wrong.

For the below updates I have seen IsInstalled and IsInstallable with nothing really inside them. Not like what your demo gif shows at least on the README.

2019-09 Cumulative Update for Windows 10 Version 1809 for x64-based Systems (KB4512578)
2019-03 Security Update for Windows 7 for x64-based Systems (KB4474419)
2019-03 Servicing Stack Update for Windows 7 for x64-based Systems (KB4490628)
Example screenshot of what I see for all of the above updates:

https://user-images.githubusercontent.com/6683266/66035606-5b3e8f80-e503-11e9-9b14-46259ee96dc3.png

Would appreciate any insight you can offer!