Short one this time!

Requirement

Use PowerShell to show missing updates on a Windows based computer (even though the SCCM Software Center does not show them).

Solution

get-wmiobject -query "SELECT * FROM CCM_UpdateStatus" -namespace "root\ccm\SoftwareUpdates\UpdatesStore" | where {$_.status -eq "Missing"}

Additional information

This one might help when certain updates are not shown because a prerequisite like a Servicing Stack Update is missing.