OPEN Query for specified installed applications

[AleksaCvijanovic]

How can I modify this query to return only the devices that have a specific application installed?
I try this but am getting error "The query statement that you entered is not valid"
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_NETWORK_ADAPTER_CONFIGURATION ON SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.ResourceID = SMS_R_System.ResourceId INNER JOIN SMS_G_System_OPERATING_SYSTEM ON SMS_G_System_OPERATING_SYSTEM.ResourceId = SMS_R_System.ResourceId WHERE SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.IPAddress LIKE "10.18.%" AND SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "Therefore%"

 

[RJ09]

How can I modify this query to return only the devices that have a specific application installed?
I try this but am getting error "The query statement that you entered is not valid"
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_NETWORK_ADAPTER_CONFIGURATION ON SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.ResourceID = SMS_R_System.ResourceId INNER JOIN SMS_G_System_OPERATING_SYSTEM ON SMS_G_System_OPERATING_SYSTEM.ResourceId = SMS_R_System.ResourceId WHERE SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.IPAddress LIKE "10.18.%" AND SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "Therefore%"

What version of sccm you're using? Try following and change app name or ip as needed. Also pick attributes under queries General tab you would like query to return.

select SMS_R_System.Name, SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.IPAddress from SMS_R_System inner join SMS_G_System_NETWORK_ADAPTER_CONFIGURATION on SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.IPAddress like "10.18%" and SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "Adobe%"