Can someone help with Simple SCCM WQL query?
I am trying to check two condition, the first is if a software is installed on a computer and the second is if that computer is belong to a AD security group.
This is the query I was build with the SCCM 2012 wizard but it doesn't work for me...
select SMS_R_System.Name, SMS_R_System.IPAddresses 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 = "Software 1.1" and SMS_R_System.SystemGroupName != "Domain\\SoftwareGroup" order by SMS_R_System.Name
This query only check the first condition and completely ignoring from the second.