There are three tools:
A tool to fix missing MSI/MSP in Windows Installer cache
A tool to browse what products are installed and their properties and patch information
A tool to view all SQL product related keys in registry just like you do with RegEdit.exe
FixMissingMSI is a tool to fix missing/mismatched MSI/MSP files in widnows installer cache folder, especially for SQL product this tool extends the capability of “FindSQLInstalls.vbs script” from below article: https://support.microsoft.com/en-us/help/969052
This tool has a friendly user interface to tell you what setup related MSI/MSP files are missing or mismatched in cached directory c:\windows\installer. It enables you recover the missing/corrupt/mismatched cached MSI/MSP files of products by one click. You can also get detailed information about the cached MSI/MSP files in the tool report. If you download service pack or CU from website you need to use X option to extract the downloaded package to extract those MSI/MSP files to the folder, to feed the tool for MSI/MSP meta data. Detailed readme please see the readme document inside the FixMissingMSI folder.
I would recommend you use Windows Installer Cache Verifier Package, as directed in KB article 2667628, to verify the cached MSI/MSP files if you use this tool to fix MSI/MSP files.
The binaries can be downloaded in Release tab or below: https://github.com/suyouquan/SQLSetupTools/releases/download/V2.0/FixMissingMSI_V2.0_ForNET4.5.zip
Note that you need NET 4.5 to run above version. If you don't have .NET 4.5 installed please download .NET 3.5 version here: https://github.com/suyouquan/SQLSetupTools/releases/download/V2.0/FixMissingMSI_V2.0_ForNET3.5.zip
Screenshot:
A tool to browse what products are installed and their properties and patch information
You can download it here:
https://github.com/suyouquan/SQLSetupTools/releases/download/v1.2/ProductBrowser_V1.2_NET4.5.zip
A tool to view all SQL product related keys in registry just like you do with RegEdit.exe
https://github.com/suyouquan/SQLSetupTools/releases/download/V2.1/SQLRegViewer_V2.0_NET45.zip
What is new in Version 2.0
Comparing to version 1.0, version 2.0 has below advantages:
1.Cached meta you scannedIf you ever scan your SP/CU folder, their meta will be cached for next run. This can save the scan time significantly.
2.Pre-processed the SQL meta files so loading time will be in seconds instead of minutes, and the size of the tool reduces from 40MB to 4MB.
3.Use multi-threading technology to load registry keys asynchronously and in parallel. This help reduce the time to scan the registry keys. With these technologies now the tool runs 2 times faster.
4.Put some scan task to background so you can get the UI sooner to browse the keys.
5.If you export the keys the result detailed text file will have remark about what the keys belongs to. For example, below entry tells you the key is for “SQL Server 2008 R2 Management Studio”:
[SQL Server 2008 R2 Management Studio] [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Components\6E63FE9FCFA1D2244BD1045FE2A00E7F]"AB3CB1820BCF65042B6B105D760D8DC8"