Hello all!
We had a customer recently when upgrading from SCCM Update Pack 1602 to 1606 that faced an issue where the right click options to install are greyed out preventing installation.
We found the below resolved the issue for us:
Firstly, take a backup of your SCCM DB just to be safe! Secondly this should be a last resort fix as making changes to the DB is done at your own risk and unsupported by Microsoft.
Open up SQL Management Studio and find the SCCM DB which is harbouring these updates. This can be found in the log, CMUpdate.log. You may notice there are some issue related to failed SQL logins using the System account.
Run the following query against the DB:
SELECT * FROM <databasename>.dbo.CM_UpdatePackages where PackageGuid=’037CD17E-4D7B-40E1-802B-14BB682364C7′ or PackageGuid=’609F1263-04E0-49A8-940B-09E0E34DE2D2′ or PackageGuid=’59bca34e-df87-4041-b9b7-f53395849e81′ or PackageGuid=’d26be618-1df5-4680-a65f-03cec6abc7ec’ or PackageGuid=’705820ef-6982-4417-8e54-307454c9a17a’;
Here you can see the updates currently viewable in the updates window within SCCM. Once you’ve done this and have confirmed updates are present, run the following command:
DELETE FROM <databasename>.dbo.CM_UpdatePackages where PackageGuid=’037CD17E-4D7B-40E1-802B-14BB682364C7′ or PackageGuid=’609F1263-04E0-49A8-940B-09E0E34DE2D2′ or PackageGuid=’59bca34e-df87-4041-b9b7-f53395849e81′ or PackageGuid=’d26be618-1df5-4680-a65f-03cec6abc7ec’ or PackageGuid=’705820ef-6982-4417-8e54-307454c9a17a’;
This will then remove the updates and following a restart of the “SMS Executive” service these will filter back in with the options full of colour.
Hope this helps!!
