Hi All,
I have sql query which list out all managed products in ITMS, but we need help in adding couple of columns to existing report such as metering and license information.
The column needs to have information like software metered (True/False) and licensed (True/False).
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
Your help on this would be much appreciated.
Thanks,
Sam