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 <br /> SMS_R_System.Name, <br /> SMS_R_System.OperatingSystemNameandVersion, <br /> SMS_R_System.ClientVersion <br /> from SMS_R_System <br /> inner join SMS_G_System_ADD_REMOVE_PROGRAMS <br /> on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId <br /> where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Google Earth" <br /> order by SMS_R_System.Name <br />
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.