+ Post New Thread
Results 1 to 6 of 6
Enterprise Software Thread, SCCM User Collections in Technical; I'm trying to create some user collections based on AD group membership, and am using the WQL query: Code: select ...
  1. #1

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    18,523
    Thank Post
    527
    Thanked 2,645 Times in 2,047 Posts
    Blog Entries
    24
    Rep Power
    924

    SCCM User Collections

    I'm trying to create some user collections based on AD group membership, and am using the WQL query:

    Code:
    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.UsergroupName = "Staff"
    But it doesn't seem to work. Thoughts?

  2. #2

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    18,523
    Thank Post
    527
    Thanked 2,645 Times in 2,047 Posts
    Blog Entries
    24
    Rep Power
    924
    Ended up using this script - Configmgr 2012 : Automate / Create User Collections from AD user Groups (based on Active Directory group discovery) | System Center Configuration Manager

    Which has created groups, but they refuse to populate. What am I missing? I've got User and Group Discoveries set up in AD, which are both working but the user collections won't populate.

  3. #3

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    18,523
    Thank Post
    527
    Thanked 2,645 Times in 2,047 Posts
    Blog Entries
    24
    Rep Power
    924
    And it appears that script doesn't work. It sticks the group inside its own user collection, and that's it. The bit for adding the users doesn't seem to stick.

  4. #4

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    18,523
    Thank Post
    527
    Thanked 2,645 Times in 2,047 Posts
    Blog Entries
    24
    Rep Power
    924
    Oh. I've got the wrong end of the stick. It only needs to contain the group! Works exactly as I need (deploying software to specific groups).

  5. #5

    Join Date
    Feb 2007
    Location
    Wolverhampton
    Posts
    331
    Thank Post
    18
    Thanked 35 Times in 33 Posts
    Rep Power
    21
    Nice little chat to yourself there

  6. #6

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    18,523
    Thank Post
    527
    Thanked 2,645 Times in 2,047 Posts
    Blog Entries
    24
    Rep Power
    924
    Yup. Well, if I want good conversation...



SHARE:
+ Post New Thread

Similar Threads

  1. SCCM 2012 Users! - How do you deploy your software?
    By OhDear in forum Enterprise Software
    Replies: 11
    Last Post: 16th September 2012, 10:20 AM
  2. SCCM Collection Query Help
    By deano in forum Enterprise Software
    Replies: 0
    Last Post: 18th May 2012, 05:24 PM
  3. Creating an SCCM collection
    By FN-GM in forum Enterprise Software
    Replies: 21
    Last Post: 31st March 2012, 09:34 PM
  4. [SCCM 2007] SCCM - Linking collections to Active Directory OU's
    By mjgreen in forum O/S Deployment
    Replies: 11
    Last Post: 28th November 2011, 09:48 AM
  5. New users
    By Dos_Box in forum General Chat
    Replies: 4
    Last Post: 3rd July 2005, 10:44 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •