SCCM Query – All Computers with a specific program install

The following SCCM collection query can be used to list all computers with a particular application and version installed.

You could use this custom collection list to deploy an update or software package only if they already have another application installed. For example, deploy the Adobe Acrobat Reader 9.3.3 update only if a version of Acrobat Reader 9.x is already installed.

 

select SMS_R_System.ResourceID,SMS_R_System.ResourceType,SMS_R_System.Name,SMS_R_System.SMSUniqueIdentifier,SMS_R_System.ResourceDomainORWorkgroup,SMS_R_System.Client
from SMS_R_System
inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId
where SMS_G_System_COMPUTER_SYSTEM.Name not in
(select distinct SMS_G_System_COMPUTER_SYSTEM.Name
from SMS_R_System
inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId
inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId
where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Adobe Reader 9%")

 

Related Articles

2 comments on “SCCM Query – All Computers with a specific program install

  1. Hi

    how can modify the sentence because i want get a report with
    hostname
    os build
    visio
    project
    office

    no matter what version or i do not want to filter or using an operator such as “Like” i need getting the software installed

Leave a Reply

Your email address will not be published.