none
Bulk User Import into SCCM 2007 Collection

    Question

  • I have a need to import around 800 users (outlined in a spreadsheet) into a collection that will be used to deploy software to.  These users are spread out among the organization and AD OU's so an OU query will not help.  I have reviewed multiple 3rd party tools (such as Right click tools, Collection Commander, etc) and have found them to only work with computer objects.  Does anyone know of a tool or script that will help here?
    Thursday, September 26, 2013 8:48 PM

Answers

  • Why don't you use an AD group to do this?

    http://www.enhansoft.com/

    • Marked as answer by VOID269 Friday, September 27, 2013 5:30 PM
    Thursday, September 26, 2013 9:04 PM
  • ucrajee,

          Thanks for the WQL query.  However having to tinker with Excel and format each account to the correct syntax seems a bit tedious and still time consuming (although no where near as much as manually entering them).

          I ended up following Garth's suggestion which lead me to my solution.  I created an AD Security Group (Universal as Global did not show up) and dumped the users into it (copy, paste, done).  I then setup the below WQL query on the collection.  This pulled all the users in.  Also on the plus side, now the Helpdesk can add and remove users as they need.

    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\\AD_Group"

    • Marked as answer by VOID269 Friday, September 27, 2013 5:30 PM
    Friday, September 27, 2013 5:30 PM

All replies

  • Why don't you use an AD group to do this?

    http://www.enhansoft.com/

    • Marked as answer by VOID269 Friday, September 27, 2013 5:30 PM
    Thursday, September 26, 2013 9:04 PM
  • Intriguing idea... I would rather the list of users be in SCCM but if all else fails, this would work.
    Thursday, September 26, 2013 10:17 PM
  • So if you try to do 800 direct membership to one collection it will likely fail, If I remember right it will fail at somewhere between ~250 - ~500.


    http://www.enhansoft.com/

    Thursday, September 26, 2013 11:27 PM
  • I'm not sure I follow what you are refering to.  By "direct membership" do you mean adding them manualy?  Or are you refering to the total number of user objects that can fit int he collection?  If that is the case, the All user's collection hase over 2000 users in it alone.
    Friday, September 27, 2013 1:30 AM
  • Hi,

    Check the below link for a collection query to add bulk machines.

    http://scorpits.blogspot.com/2013/09/wql-query-to-add-bulk-computers-to-sccm.html

    Hope that helps..


    ~ Rajeesh M | My Blog: ScorpITs | Please take a moment to 'Mark as Answer' or 'Vote as Helpful' on the post that helps you. It helps others reading the thread; recognizes useful contributions.

    Friday, September 27, 2013 9:36 AM
  • ucrajee,

          Thanks for the WQL query.  However having to tinker with Excel and format each account to the correct syntax seems a bit tedious and still time consuming (although no where near as much as manually entering them).

          I ended up following Garth's suggestion which lead me to my solution.  I created an AD Security Group (Universal as Global did not show up) and dumped the users into it (copy, paste, done).  I then setup the below WQL query on the collection.  This pulled all the users in.  Also on the plus side, now the Helpdesk can add and remove users as they need.

    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\\AD_Group"

    • Marked as answer by VOID269 Friday, September 27, 2013 5:30 PM
    Friday, September 27, 2013 5:30 PM
  • Also, to my comment about "I would rather the list of users be in SCCM" I thought all that would show up was the group in the collection, which it did, until I corrected my syntax.
    Friday, September 27, 2013 5:33 PM
  • I see that you when with the group method but yes I did mean manually adding them to a collection.

    http://www.enhansoft.com/

    Saturday, September 28, 2013 3:48 PM