SCCM Query help


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.


December 3rd, 2013 9:04am

You have to use to exclude systems. != does not work in that case.
Free Windows Admin Tool Kit Click here and download it now
December 3rd, 2013 12:58pm

On top of Torsten comment, keep in mind that your query will only find x86 software you will need to add the x64 to get everything.
December 3rd, 2013 2:22pm

select displayname0, "memberof"=

case when resourceid  in # pull all your member of AD objects #

else "not a member"


from V_GS_ADD_remove_programs.

hope this logic will work out.

Free Windows Admin Tool Kit Click here and download it now
January 26th, 2014 9:44am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics