This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Remove From My Forums

SCCM 2012 | User Collection based on Active Directory User Group

Question
0

Sign in to vote

I feel so stupid right now... I for the life of me can not figure out how to create a user collection that would show "x" number of users in the user collection screen based on a active directory group.

More detail: Have AD group called "GroupA" and it has 50 users in it. How do I make a user collection that would list out all 50 users from that group?

Please and thank you!

-Eric

Wednesday, June 12, 2013 3:40 PM

Answers

10

Sign in to vote
Hi,

Add a query rule to your collection's membership rule and add the "user resource / security group name" criteria.

Regards,
My technet galleries contributions : ConfigMgr driver injector // SCCM Collection splitter
- Marked as answer by Eric Weintraub Wednesday, June 12, 2013 6:12 PM
Wednesday, June 12, 2013 3:44 PM
6

Sign in to vote
use this: select * from SMS_R_User where SMS_R_User.SecurityGroupName = "VIAMONSTRA\\SW_7-ZIP_Install"
Kent Agerlund | My blogs: blog.coretech.dk/kea and SCUG.dk/ | Twitter: @Agerlund | Linkedin: Kent Agerlund | Mastering ConfigMgr 2012 The Fundamentals
- Proposed as answer by Sherry Kissinger Wednesday, June 12, 2013 4:39 PM
- Marked as answer by Eric Weintraub Wednesday, June 12, 2013 6:12 PM
Wednesday, June 12, 2013 4:06 PM

All replies

10

Sign in to vote
Hi,

Add a query rule to your collection's membership rule and add the "user resource / security group name" criteria.

Regards,
My technet galleries contributions : ConfigMgr driver injector // SCCM Collection splitter
- Marked as answer by Eric Weintraub Wednesday, June 12, 2013 6:12 PM
Wednesday, June 12, 2013 3:44 PM
6

Sign in to vote
use this: select * from SMS_R_User where SMS_R_User.SecurityGroupName = "VIAMONSTRA\\SW_7-ZIP_Install"
Kent Agerlund | My blogs: blog.coretech.dk/kea and SCUG.dk/ | Twitter: @Agerlund | Linkedin: Kent Agerlund | Mastering ConfigMgr 2012 The Fundamentals
- Proposed as answer by Sherry Kissinger Wednesday, June 12, 2013 4:39 PM
- Marked as answer by Eric Weintraub Wednesday, June 12, 2013 6:12 PM
Wednesday, June 12, 2013 4:06 PM
0

Sign in to vote
Perfect, thanks guys.
- Proposed as answer by Ravindra Bhosale Thursday, October 2, 2014 11:04 AM
Wednesday, June 12, 2013 6:12 PM