I got my System Center Configuration Manager (SCCM) Current Branch with an In Console update stuck installing and/or with incorrect status reported.
The latest update for SCCM Current Branch (KB4339794) was incorrectly reporting an installed status on both Update and Servicing workspace and on Update and Servicing Status while it was in fact stuck installing (as shown in the screenshots below)
If you search on the Internet for solution for this situation you will find lot of solutions involving running some sort of SQL Query to clear the status and resume the process. In fact there are really bad solution as this is unsupported to perform direct operation on the SCCM database (unless instructed by Microsoft Support).
Thankfully, with SCCM Current Branch, Microsoft has introduced a very useful (and probably unknown) utility CMUpdateReset.exe to help in resetting (and even deleting) the status of an In Console update.
To use it, you need to run it from a command prompt (as usual use the Run As Administrator) and go to the cd.latest\SMSSETUP\TOOLS\CMUpdateReset directory (usually located within the SCCM installation directory – C:\Program Files\Microsoft Configuration Manager\cd.latest\SMSSETUP\TOOLS\CMUpdateReset)
Then run the tool by providing the SQL FQDN, SQL Instance (if not using the default one), the SCCM database and the GUID of the stuck update.
You can get the GUID of the update either from the SCCM console or by browsing to the EasySetupPayload directory
“C:\Program Files\Microsoft Configuration Manager\cd.latest\SMSSETUP\TOOLS\CMUpdateReset\CMUpdateReset.exe” –S <FQDN of the SQL server> –I <SQL Instance – do not use it if you use the default instance> –D <SCCM Database> –P <Update GUID>
The –FDelete parameter can be used if you want to force the deletion of the package and re download it.
Once successfully completed you can restart the update installation.