lidoiwo

How do I write a sql script that will list applications installed on each computer in a collection and exclude security patches or any other common apps I want to exclude.

JeffreyJRiggs

try something like this.. just something to start with...

Select t2.[ResourceGUID]
FROM [vCollection] t1 innerjoin
[CollectionMembership] t2 on t1.GUID = t2.CollectionGUID innerjoin
[Inv_Aex_AC_Identification] t3 on t2.ResourceGUID = t3._resourceGUID innerjoin
[Inv_Aex_OS_Add_Remove_Programs] t4 on t3._resourceGUID = t4._ResourceGuid
WHERE t1.[Name] = 'All computers'
AND t4.[Name] like '%Adobe Reader%' and t3.[OS Name] like '%XP%'

__________________
SQL Fundamentals 101:
SELECT * FROM dbo.User WHERE Clue > '0'
Query batch completed, 0 rows