Bulk creating users in AD?

[Sephiroth]

@pcstru I have something similar here. 3 scripts and a DB to do it, but works for me. All automated and runs every night. Most of the time, students have their accounts before the staff know they exist (or I do, for that matter!).

 

I have a script to pull house, year, form, admission (used for their username, so all are unique by design), SIMS UPN, and name from sims (as well as generating a temporary password and working out what the year of entry would be if they joined at year 7) into my own database table; I pull student class codes and subjects, listed per student, into a table; I pull all staff name, code, subject (main where applicable) and role into a table; and I pull all generated student groups (with appropriate prefixes) into a table. Each row is flagged 'modified' if there's been a change to the record.

 

I then have a script that reads from that and checks for the modified flag or active flag and updates or creates as necessary. It sets up the home directory including quotas and file screens, along with all the group mappings and filling in AD fields.

 

I have a 3rd script which creates Exchange contacts for each student, put's the contact in the correct groups so that they are put into the correct address lists and contact groups, then collates all information into emails to relevant people (1 per staff member, regardless of number joining a class) and emails me a full log (also stored in the DB).

[pcstru]

Sounds awesome. You should open source it for everyone else, and hopefully they'll support it when you leave

I've posted most of the relevant code in the coding forum in one form or another, but the example DB pulls will be for the CMIS database. The actual code is unfortunately quite closely coupled to the way we do things (how we code tutor groups etc and how that is all processed into OU's, server paths etc). Not sure I could justify abstracting it so that it is generally usable (and easy to use).