SCCM WQL Query: Finding Devices with Google Earth Installed

If you want to identify machines with Google Earth installed, you can query it using the Add/Remove Programs (ARP) software inventory data ConfigMgr collects from clients.

The 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 like "%Google Earth%"

Using It

Paste this into a new query or a collection’s Query Rule (Query Language tab) the same way as any other WQL-based rule. This depends on Add/Remove Programs inventory being enabled in your client settings and clients having reported recently — if Google Earth is installed per-user rather than machine-wide on some systems, it may only show up in the ARP data for the user context it was installed under, so cross-check against a sample machine if you get fewer results than expected.

Catching both “Google Earth” and “Google Earth Pro”

The LIKE "%Google Earth%" wildcard already catches both product names, since “Google Earth Pro” contains the string “Google Earth” — you don’t need a separate OR clause for it. If you specifically want to split them apart in your results (e.g. to report Pro vs. standard installs separately), add the display name to your SELECT list so you can see which variant each row matched:

select distinct SMS_R_System.Name, SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName, SMS_R_System.OperatingSystemNameandVersion 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 like "%Google Earth%"

Confirming on a single machine without waiting for inventory

If you need to check a specific machine right now rather than waiting for its next hardware inventory cycle to reach ConfigMgr, run the equivalent check locally via PowerShell:

Get-ItemProperty HKLM:\Software\Microsoft\Windows\CurrentVersion\Uninstall\* | Where-Object { $_.DisplayName -like "*Google Earth*" } | Select DisplayName, DisplayVersion

This reads the same uninstall registry data that ConfigMgr’s ARP inventory is ultimately sourced from, so it’s a reliable way to confirm what the WQL query above should eventually pick up once that machine’s next inventory cycle runs.

Resources

• query
• WQL
• our SQL & WQL query library
• Download Now →
• Browse our Windows Admin Toolkit picks on Amazon