Author: Heath Stewart
Vendor: Microsoft

Summary
[From the Author] 
Windows Installer patches can target multiple products, and Developer Division makes a practice of shipping patches that take advantage of this capability. This typically helps avoid confusion among users about which patch to download. However, because Visual Studio ships as many editions and even the Integrated Development Environment, or IDE, is used by other divisions such as SQL Server, it's not always clear to which products a patch applies and if you have that product installed.

Details
Visual Studio is an example as set by the author and there could be many patches that we want to know quickly representing the core application. To help eliminate confusion in this case, the author have created the Patch Applicability Browser. It's a simple application with a simple purpose: display what products a patch targets, and identify which of those products are installed on the machine.

Download: All Platforms

More Info
Patch Applicability Browser
Introducing the Patch Applicability Browser 

Author's Note:
I will update the internal data set from time to time and may improve upon this application based on user feedback. Please provide such feedbacks.