Here is some SQL to get you started. It will list all discovered or "installed" software, which software product it's associated to (if it exists), the company for that product, and the Managed State (Managed, Unmanaged)
SELECT sci.Name AS [Discovered Application]
,ISNULL(prod.prodName, '') AS [Software Product]
,ISNULL(prod.compName, '') AS [Company]
,CASE WHEN prod.IsManaged = 1 THEN 'Managed'
WHEN prod.IsManaged = 2 THEN 'Unmanaged'
ELSE '' END AS [Managed State]
FROM vRM_Software_Component_Item sci
LEFT JOIN (SELECT ra.ChildResourceGuid AS compGuid, sps.IsManaged, sp.Name AS prodName, cmpy.Name AS compName
FROM ResourceAssociation ra
JOIN RM_ResourceSoftware_Product sp
ON sp.Guid = ra.ParentResourceGuid
JOIN Inv_Software_Product_State sps
ON sps._ResourceGuid = sp.Guid
LEFT JOIN (SELECT [Guid], [Name], ParentResourceGuid AS product
FROM ResourceAssociation ra
JOIN vRM_Company_Item company
ON Guid = ChildResourceGuid
WHERE ra.ResourceAssociationTypeGuid = 'D5C66d5A-7686-4CA2-B7C1-AC980576CE1D') cmpy
ON cmpy.product = sp.Guid
WHERE ra.ResourceAssociationTypeGuid = '9D67B0C6-BEFF-4FCD-86C1-4A40028FE483') prod
ON prod.compGuid = sci.Guid
WHERE sci.Guid IN (SELECT _SoftwareComponentGuid FROM Inv_InstalledSoftware WHERE InstallFlag = 1)
ORDER BY sci.Name