locked
SCCM Query help RRS feed

  • Question

  • Hello,

    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.

    Thanks.

    Tuesday, December 3, 2013 6:04 AM

Answers

All replies