Wanna impress your project leader?

Posted by

Whatever you are doing deploying applications, migrating mail server, AD migration, organize an event or conference you need a list of people, some information and maybe a status like the response of an email.

SharePoint is great product to for example manage list and Active Directory is a great directory for example users.

So what do we need to impress our project leader? Yes, a PowerShell synchronization!

First prepare SharePoint with a new site and a custom list except for the automatically added Title column add the following columns: User, FirstName, LastName, LoginName, OldLoginName, Description, PhoneNumber, Email, Sid, Site List. (Add more columns according to your needs)


Now you are ready to run the script, I used a command similar to this, everything on a single line:

.\Sync-AdToSPList.ps1 http://localhost/ Site1 AfterWork company.corp “LDAP://OU=Users,OU=Malmo,DC=company,DC=corp” “Malmo”

Now wait until it’s done and when you refresh the page in SharePoint you will see all users added, now to a feature!

If you re-run the script you will notice that all users will be updated and not added again! The script is made to found and update according to the SID of the users since this is the only thing that will not change. (Note it will not cleanup disabled or deleted users, that’s a feature to come!)

The script and the SharePoint list is available for download from my Skydrive!



Many thanks to my co-worker Niklas from www.powershell.nu!

One comment

  1. Great – I should certainly pronounce, impressed with your site. I had no trouble navigating through all tabs as well as related info ended up being truly easy to do to access. I recently found what I hoped for before you know it at all. Quite unusual. Is likely to appreciate it for those who add forums or something, website theme . a tones way for your customer to communicate. Excellent task.


Leave a comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.