Created a package with associated Device collection. The following query is used to deploy the application.
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_INSTALLED_SOFTWARE on SMS_G_System_INSTALLED_SOFTWARE.ResourceId = SMS_R_System.ResourceId where SMS_R_System.Name = "MachineName" and SMS_G_System_INSTALLED_SOFTWARE.ARPDisplayName like "%SAP GUI for Windows 7%"
or
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_INSTALLED_SOFTWARE on SMS_G_System_INSTALLED_SOFTWARE.ResourceId = SMS_R_System.ResourceId where SMS_R_System.Name in ('MachineName','MachineName2') and SMS_G_System_INSTALLED_SOFTWARE.ARPDisplayName like "%SAP GUI for Windows 7%"
Any thoughts on why this query is not working. The executable will not deploy on the chosen PC .
Can someone direct me to right forum where I can ask questions on system center configuration Manager
