Release Notes

These scripts helps for manage MOSS Profile Users or SPUsers informationThe first script checks each SPuser (SharePoint User) existence in each Site Collection of the given Web Application if exists.The script calls the Active Directory for each user with the login name of the SPUser.

You can execute the script with this command :

Check-SharePoint-Orphaned-Users.ps1 > orphaned_users.txt

After execution open the txt file and use the second PowerShell script for SPUser deletion :

Execute the script by use the file name "Set-WSS-UserInfo-From-ActiveDirectory.ps1"

All the User data will receives the information, you can modify the script if you have extended data.The forth script shows you the permissions for the specified user in all sites and lists in a web application

creates a new SharePoint site group using a file previously created by this script or a manually composed file as input

adds members to a SharePoint site group using a previously created by this script or manually composed file as input

clears all members from a SharePoint group

The seventh script lists all the site groups and their members in a site collection in XML formatThe eighth script load all the Active Directory Users from the given OU to a given SharePoint contacts listYou can modify the script file for adapt the Active Directory connection string (With the possible Organization Unit) and the Contact list Name and URL

The ninth script retrieves effective permissions for a specified Windows user/group account or all accounts for any part of a SharePoint web application.

It is commented in a style compatible with the PowerShell V2 comment-based help feature, so you can obtain full usage information by running:

Get-Help .\Get-EffectiveSPPermissions.ps1 -detailed

The tenth script load all the MOSS Profiles in a SQL Server DataBase (specified in the connection string, with the given table name).

You have also to modify the URL of your MOSS farm at the end of file.The file is executed directly with his name.

The eleventh script export all the MOSS Profiles in an XML file.The file is executed directly with his name.The twelfth script create a SharePoint MOSS Audience with the specified values and compile itThe Thirteenth script create or list the SharePoint MOSS Personalized linksThe Fourteenth script create a job and execute the profiles Import

Marc Lognoul [MVP]Fabrice Romelard {

Reviews for this release

I use the Set-WSS-UserInfo-From-ActiveDirectory script in our production environment... works like a charm. Thanks for this!
by BaldwinD
on Jun 6, 2013 at 8:50 PM

The Get-EffectiveSPPermissions script was exactly what we needed for auditing users permissions, surprised it is free with the amount of time someone put into this script. Thank you!!
by rfiscus
on Apr 10, 2012 at 6:43 PM

Very useful script and has most probably saved me hours of work. I just need to ask how would I now pipe this output in the Check-Delete-SharePoint-Users.ps1 as I have some 800 orphaned accounts to delete accross 34 site collections?
by beatleuk
on Apr 21, 2009 at 4:10 PM

Excellent work, I'm MVP MOSS - EROL and more the user and admin see PowerShell for MOSS better is the life !
by EROL
on Feb 17, 2009 at 5:24 PM