Active Directory Account Creation & Disable script based on SIMS data.

[FN-GM]

Hello,

 

Does anyone have any script that will automatically create and disable accounts based on SIMS data please? Basically a very cut down version of Salamander.

 

I am doing some work with a school in my personal time (for free if that matters) that is in a bit a of mess IT wise. So we can't afford paid software at the moment. Something like this would help greatly.

 

Many Thanks

[ADMaster]

I assume sims is capable of an automated csv export?

 

I wrote a script that has two foreach loops at its core.

One loops though the csv creating new accounts, the second loops though the students OU disabling accounts that are not in the csv.

 

It does much more, but that's the gist.

[FN-GM]

I assume sims is capable of an automated csv export?

 

I wrote a script that has two foreach loops at its core.

One loops though the csv creating new accounts, the second loops though the students OU disabling accounts that are not in the csv.

 

It does much more, but that's the gist.

 

It is possible yes. If you could share the script it would be very useful.

 

 

Thanks

[nickbro]

Hi guys, this is the PS script I wrote

 

Hope it helps

userupdatescript.txt

[FN-GM]

Thanks Nick. I will take a look when I get on my PC.

[ADMaster]

I've got mine sanitized of school specific data now. Nicks looks much nicer and connects to sims for you, but here is mine if you want to take a peek.

 

A few notes;

I put the student ID in the pobox field this is the unique key for all changes

I work from students grad year, not intake like many of you.

All students are put into a security group of their grad year, and have that put in the description field. The description field can then be parsed to identify grade level changes in case of early advancement or failure.

I have multiple buildings that are accounted for in the OU structure.

All the aup check stuff is commented out, it caused a catch 22 when we went to online forms.

This is designed to be run as a scheduled task and will email you a change report.

It connects to an sftp server to download the data as my SIS not not on site.

 

 

After cleaning this up I've noticed a few changes and cleanup I can do, but here it is, as is.

addusers.txt

Edited June 5, 2018 by ADMaster

[FN-GM]

Thanks for the reply. Much appreciated.

 

Thanks

[FN-GM]

Hello - I am picking this project back up. I will be playing around with this soon. How would it work if there are existing users please? How would it know not to create new accounts that will be then duplicates please?

[mavhc]

That is the main problem, the sim2ad script I took over matched first and surnames and middle names and then wrote the UPN into a spare AD field

 

Then if it thinks it's a different person, but a user already existed with that name it adds a number to the end

 

https://code.google.com/archive/p/sims2ad/downloads

[Norphy]

The way I’ve got around that is to put a base64 encoded version of the student UPN into the EmployeeNumber field in the AD account. When my script loops through the CSV file, it first looks for the UPN and skips it if found.

 

I’m willing to put my script up if you want to compare and contrast.

[FN-GM]

The way I’ve got around that is to put a base64 encoded version of the student UPN into the EmployeeNumber field in the AD account. When my script loops through the CSV file, it first looks for the UPN and skips it if found.

 

I’m willing to put my script up if you want to compare and contrast.

 

That would be fab.

 

How about staff please?

[Norphy]

Staff was a bit harder as I found it next to impossible to find a field in SIMS that was actually populated for everyone. It turned out that there was a database ID field which everyone had so that went into the employeenumber field in their AD account

[ITGuyWestMidlands]

You may be able to use the person Id field for both staff and students. You will need to be a member of the Third Part Reporting role to access this though.