I'm trying to create a collection of computers based on whether the last logged in user is a member of an AD user group. I've found a couple of examples, but something is not right with the syntax. People keep putting in xxxx/security group, but they don't say what xxx is supposed to be. I've tried domain and it didn't work. Here is the example I have been working with: 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 where SMS_R_System.SystemGroupName like "XXX\\Sccm Deployment iTunes" If my domain name is ACME and my user/security group is Sales Team, how should I write this query? And before some helpful person points out the obvious, I know I really should learn SQL query language. I'm trying to get around to it. Thanks

There is no table or view as SMS_R_USERGROUP in sccm 2007 .

There is no table or view as SMS_R_USERGROUP in sccm 2007 . SMS_R_UserGroup is a WQL table name, it is to be used for query / collections. The same SQL view name is called v_R_UserGroup. http://www.enhansoft.com/