The question I get asked most about Patch Management is "What products can I actually patch?". This answers that question at last.
After running the PMI Task, even if a product is "Checked" or not this report will return a list of all possible Products (By Vendor) that you can Patch.
For now I'm uploading only SQL, later I will add search Parameters in xml format.
Select comp.Name AS [Company], vi.Name AS [Product]
From Inv_Software_Release_Platform rp
INNER JOIN ResourceAssociation ra
ON ra.ParentResourceGuid = rp._ResourceGuid
AND ra.ResourceAssociationTypeGuid = '292dbd81-1526-423a-ae6d-f44eb46c5b16'
LEFT JOIN RM_ResourceCompany comp
ON ra.ChildResourceGuid = comp.Guid
INNER JOIN RM_ResourceSoftware_Release vi
ON vi.Guid = rp._ResourceGuid
ORDER BY 1,2