Report of the software which is in the state of unmanage. How to generate it?
Check the thread query
https://www-secure.symantec.com/connect/forums/report-unmanaged-software
See cnpalmer75 comments
This query will return exactly what you see in your Managed Software list...
SELECT DISTINCT
[vri2_Software Product].[Name] AS [Name]
FROM
[vRM_Software_Product_Item] AS [vri2_Software Product]
INNER JOIN [Inv_Software_Product_State] AS [dca3_Software Product State]
ON ([vri2_Software Product].[Guid] = [dca3_Software Product State].[_ResourceGuid])
INNER JOIN [vAC_ManagedSoftwareProducts] AS [ajs4_vAC_ManagedSoftwareProducts]
ON ([vri2_Software Product].[Guid] = [ajs4_vAC_ManagedSoftwareProducts].[Guid])
LEFT OUTER JOIN ([ResourceAssociation] AS [ajs5_ra]
LEFT OUTER JOIN [vRM_Company_Item] AS [ajs6_vRM_Company_Item]
ON ([ajs5_ra].[ChildResourceGuid] = [ajs6_vRM_Company_Item].[Guid]))
ON ([vri2_Software Product].[Guid] = [ajs5_ra].[ParentResourceGuid])
LEFT OUTER JOIN [Inv_Software_Image] AS [ajs7_Inv_Software_Image]
ON ([vri2_Software Product].[Guid] = [ajs7_Inv_Software_Image].[_ResourceGuid])
WHERE [dca3_Software Product State].[IsManaged] = 1
ORDER BY [Name] ASC