SCCM 2012 - WQL Query for devices with specific software installed
If you want to identify machines with a specific piece of software installed, you can utilise the Add/Remove Programs software inventory to do this by using this query.

 select distinct  
      SMS_R_System.Name,   
      SMS_R_System.OperatingSystemNameandVersion,   
      SMS_R_System.ClientVersion   
 from SMS_R_System  
      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 = "Microsoft Office Professional Plus 2010"  
      order by SMS_R_System.Name

In this example, we are using "Microsoft Office Professional Plus" - however, you can change this value to anything you like (that matches the Add/Remove Programs software inventory) to bring back the required information.

If you have any problems with this query, please leave a comment below.

Labels: , ,