Collection based on an AD group and specific collection

[JPUK 0]

hi there

 

I have created a collection that is based on the end user being a member of a group, this works fine

 

select SMS_R_USER.ResourceID,SMS_R_USER.ResourceType,SMS_R_USER.Name,SMS_R_USER.UniqueUserName,SMS_R_USER.WindowsNTDomain from SMS_R_User where SMS_R_User.UserGroupName = "Domain\\UserGroup"

 

However I would like to restrict even further which machines that this is advertised to, so I have limited the collection that the query uses to the one I want. When I run the query I get no results back, remove the collection limit, all is okay.

 

is this possible first of all, and if so what am I missing?

 

any help or advice would be appreciated