SQL query – computers where an app is NOT installed
SQL query which will return the computers, where a given application is NOT installed…
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
select distinct RID.Name0 from v_R_System RID inner join v_GS_COMPUTER_SYSTEM on v_GS_COMPUTER_SYSTEM.ResourceID = RID.ResourceID JOIN v_FullCollectionMembership fcm on RID.ResourceID=fcm.ResourceID where fcm.CollectionID='PS100017' AND v_GS_COMPUTER_SYSTEM.Name0 not in ( select distinct Name0 from v_GS_COMPUTER_SYSTEM join v_GS_ADD_REMOVE_PROGRAMS on v_GS_ADD_REMOVE_PROGRAMS.ResourceID = v_GS_COMPUTER_SYSTEM.ResourceId JOIN v_FullCollectionMembership on v_FullCollectionMembership.ResourceID = v_GS_COMPUTER_SYSTEM.ResourceId where v_GS_ADD_REMOVE_PROGRAMS.DisplayName0 like '%infopath%' and v_FullCollectionMembership.CollectionID = 'PS100017' ) |