Sims2ad integration.

Hi all,

I am currently in the process of re-writing the sims2ad vb script and changing it to a moodle block.

The question i have could people supply the format of their usernames ie

[Intake Year][Initial First Name][Initial Middle Name][Surname]

i would like to include as many formats as possible.

[First Initial][Middle Initial][Surname]
Though not all kids/staff have a middle initial!

@Gatt,

Thanks

Another question to add.

Does you ad structure mirror the following structure?

OU=[School Name]
+=Year [Intake Year]

ie

OU=School
+= Year 07
+= Year 08
etc

OU=School
+=Users
++=Pupils
+++=Year 07
+++=Year 08
etc

Quote:

---

Originally Posted by Gatt

[First Initial][Middle Initial][Surname]
Though not all kids/staff have a middle initial!

---

What happen if you have two people with the same name?

we add an incremental number at the end

jbloggs
jbloggs1
jbloggs2
etc

[2-digit-YoE]+[Surname]+[FirstInitial] e.g. 08BloggsJ - if there is say a John & a Jane, then 08BloggsJo & 08BloggsJa

OU=School
+=Users
+=Students
+=?? Intake (?? being YoE)

Staff and students: (firstname).(lastname)[i]

joe.bloggs
joe.bloggs1

[Entry Year][Surname][Initial]

08BloggsK
08BloggsK1

Staff are either [Initial][Surname] or [Surname][Initial] (Mix of both for some reason).

CC3 network for AD Structure

You know that Capita to a AD provisioning plug in for SIMS ? And I think it lets you use some sort of regular expressions to assign usernames (it certainly let me do this for our SLG users).

Staff: First 4 letters of firstname, first four letters of surname, so GordBrow, this is what we use for SIMS.net and AD domains.
I was talking to a new member of staff who'd had logging on issues, due to the fact at his previous school they use first three of the forename and first 3 of the surname.

For students it is just [surename][forename initial][as many middle name initials as I can get][numeric counter if more than one]

(so how I managed to get SmithC5 is because, I have 6 students with no middle names, but the forenames start with a C).


We have students in AD as [ /students/2009Entry/{username} ]


If you want to confuse matters, we also store the users home folder in [ d:\users\09\{form}\{username} ] which we share out to the user as [ \\servername\{username} ]
whereas staff are in [ d:\users\staff\{teachers or support}\{username} ].

Quote:

---

Originally Posted by User3204

You know that Capita to a AD provisioning plug in for SIMS ? And I think it lets you use some sort of regular expressions to assign usernames (it certainly let me do this for our SLG users).

Staff: First 4 letters of firstname, first four letters of surname, so GordBrow, this is what we use for SIMS.net and AD domains.
I was talking to a new member of staff who'd had logging on issues, due to the fact at his previous school they use first three of the forename and first 3 of the surname.

For students it is just [surename][forename initial][as many middle name initials as I can get][numeric counter if more than one]

(so how I managed to get SmithC5 is because, I have 6 students with no middle names, but the forenames start with a C).


We have students in AD as [ /students/2009Entry/{username} ]


If you want to confuse matters, we also store the users home folder in [ d:\users\09\{form}\{username} ] which we share out to the user as [ \\servername\{username} ]
whereas staff are in [ d:\users\staff\{teachers or support}\{username} ].

---

Hi ,

Yes I am aware of the AD provisioning with SLG.

Our LA is looking at hosting our SLG so the we will have to hand over control of our ad domain to allow single sign on.

We prefer to use as little MS software as possible, save the continual upgrade cost.

I will add your username format to the list, i will look into the folder creation part later on, we currently use a samba server to host out home folders as it creates the home directories on first logon.

students: 4 digit admission number (but changing these to 6 next year)
staff: staff code in SIMS

Quote:

---

Originally Posted by penfold_99

Our LA is looking at hosting our SLG so the we will have to hand over control of our ad domain to allow single sign on.

---

SLG accounts can be consolidated against different AD domains, so technically there's no reason that the LA shouldn't be able to provision to a domain of their own, then consolidate those accounts against your own internal domain for single sign-on.

This does require trusts to be set up correctly.

Quote:

---

Originally Posted by Hightower

CC3 network for AD Structure

---

@Hightower,

Could you expand? as i have never seen a CC3 network

Hi Penfold,

Could you tell me how I could modify this script so I could use pupil admission numbers for their logins/home drives?

Currently, I have setup the view in SQL which I've slightly modified to also select student admission number and strip out the leading zeros. It then puts these in another column, Expr1.

Thanks chap :)