:::: MENU ::::

Specific application From specific Collection ID

SELECT DISTINCT c.Name0 AS [Machine Name] , a.DisplayName0 AS [software name], a.Version0 AS [Version], dbo.v_FullCollectionMembership.CollectionID
FROM dbo.v_Add_Remove_Programs AS a INNER JOIN
dbo.v_R_System AS c ON a.ResourceID = c.ResourceID INNER JOIN
dbo.v_FullCollectionMembership ON c.ResourceID = dbo.v_FullCollectionMembership.ResourceID
WHERE (a.DisplayName0 LIKE ‘JAVA%’) AND (dbo.v_FullCollectionMembership.CollectionID IN (‘XXXXX’))


So, what do you think ?