I don't think you have the correct query. You are trying to look for user groups, you need to look for users who are a member of a group. See a working query we use below.
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\\\\V_Adobe_AcrobatProfessional_8_UNINSTALL" Daniel Ratliff From: [email protected] [mailto:[email protected]] On Behalf Of Jeff Poling Sent: Thursday, October 17, 2013 10:04 AM To: [email protected] Subject: Re: [mssms] Collections won't update my AD groups Have you tried manually doing an AD Group discovery? On Thu, Oct 17, 2013 at 8:40 AM, Brian McDonald <[email protected]<mailto:[email protected]>> wrote: I am attempting to create 2 collections for my Microsoft Office 2013 installation. In AD, I have created the following domain local security groups: SW_Office_2013_Uninstall SW_Office_2013_Install In ConfigMgr, I have created two collections with the same naming convention. Here is the query I'm using: select SMS_R_USERGROUP.ResourceID,SMS_R_USERGROUP.ResourceType,SMS_R_USERGROUP.Name,SMS_R_USERGROUP.UniqueUsergroupName,SMS_R_USERGROUP.WindowsNTDomain from SMS_R_UserGroup where SMS_R_UserGroup.Name = "MYDOMAIN\\SW_Office_2013_Uninstall" I then ran a full discovery on the AD Group Discovery, then updated my collection memberships. I cannot get the AD groups to show in my member count properly. If I go to edit the query and select value I do not see the AD groups I created in the list. Are there any specific logs or anything I should be looking at to investigate this further? Thank you, Brian The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.
