SCCM 2012 - WQL Query for devices with Google Earth installed
If you want to identify machines with Google Earth 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 = "Google Earth"  
      order by SMS_R_System.Name

This WQL query can then be used as part of an import function to create a device collection within SCCM.

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

Labels: , ,