NEW WQL query to find Google Earth Pro installations to set up a collection

[ScottyLeach]

Hi all,

I've tried the following two queries and various mods of them. Both are coming up with zero results, when the report (Software 02D - Computers with specific software installed) is showing 132 instances. Can someone please point me in the right direction? THANKS!
1. 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_SoftwareProduct on SMS_G_System_SoftwareProduct.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareProduct.ProductName = "Google Earth Pro" and SMS_G_System_SoftwareProduct.ProductVersion like "7.3.%" order by SMS_R_System.Name
2. 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_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 Pro" order by SMS_R_System.Name

 

[Garth]

Hi all,

I've tried the following two queries and various mods of them. Both are coming up with zero results, when the report (Software 02D - Computers with specific software installed) is showing 132 instances. Can someone please point me in the right direction? THANKS!
1. 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_SoftwareProduct on SMS_G_System_SoftwareProduct.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareProduct.ProductName = "Google Earth Pro" and SMS_G_System_SoftwareProduct.ProductVersion like "7.3.%" order by SMS_R_System.Name
2. 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_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 Pro" order by SMS_R_System.Name

The Second query will only find x86 versions, you need to query the x64 view to get those.
The first query isn't using the AI data, you need to look at Installed SW view instead. SMS_G_System_INSTALLED_SOFTWARE

 

[ScottyLeach]

The Second query will only find x86 versions, you need to query the x64 view to get those.
The first query isn't using the AI data, you need to look at Installed SW view instead. SMS_G_System_INSTALLED_SOFTWARE

Thanks Garth, I'll try this.