SharePoint Users Management

Rating:        Based on 4 ratings
Reviewed:  4 reviews
Downloads: 56274
Released: Mar 10, 2011
Updated: Jan 26, 2012 by sezel
Dev status: Stable Help Icon

Recommended Download

Source Code Get-EffectiveSPPermissions
source code, 35K, uploaded Jan 26, 2012 - 9973 downloads

Other Available Downloads

Source Code Check-SharePoint-Orphaned-Users
source code, 4K, uploaded Feb 20, 2009 - 7699 downloads
Source Code Get-MOSS-Profile-User-Details
source code, 2K, uploaded Jan 15, 2009 - 4110 downloads
Source Code Set-WSS-UserInfo-From-ActiveDirectory
source code, 8K, uploaded Feb 13, 2009 - 4748 downloads
Source Code Check-Permissions-SharePoint-Users
source code, 5K, uploaded Feb 2, 2009 - 8695 downloads
Source Code spMigrateUser
source code, 1K, uploaded Jun 5, 2009 - 3288 downloads
Source Code Edit-SPGroup
source code, 17K, uploaded Jul 30, 2009 - 2526 downloads
Source Code Get-SiteGroups
source code, 5K, uploaded Jul 30, 2009 - 4280 downloads
Source Code Set-WSS-Contact-List-From-ActiveDirectory
source code, 8K, uploaded Sep 25, 2009 - 2156 downloads
Source Code Set-MOSS-Profiles-To-SQLServer
source code, 8K, uploaded Dec 17, 2009 - 1594 downloads
Source Code Export-MOSS-Profiles-XML
source code, 2K, uploaded Dec 16, 2009 - 1531 downloads
Source Code Create-New-SharePointAudience
source code, 5K, uploaded Jan 13, 2010 - 1633 downloads
Source Code Get-Create-SharePoint-PersonalizedLinks
source code, 4K, uploaded Jan 18, 2010 - 1046 downloads
Source Code Refresh-User-Profiles
source code, 2K, uploaded Jan 4, 2012 - 2099 downloads
Source Code Refresh-Audiences
source code, 3K, uploaded Jan 4, 2012 - 896 downloads

Release Notes

These scripts helps for manage MOSS Profile Users or SPUsers information

The 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 :
The second script shows all information about a MOSS Profile User (given by his login)
  • Get-MOSS-Profile-User-Details "http://myWebApplication" "DOMAIN\Login"

The third script synchronizes all Site Collections User information between SharePoint (WSS or MOSS) and Active Directory
  • For execute this script, you have to :
    • Open the PS1 file
    • Modify the line 198: [ Set-UserInfoDetails "http://mySharePointWebApplication" "LDAP://DC=MyControler,DC=MyDomain,DC=com" ] with your internal parameters
    • 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
  • For execute this script
    • You have to modify the two lines:
[string]$userlogintocheck = "DOMAIN\User_login"
ListUsersForAllCollections "http://myWebApplication" $userlogintocheck
  • Execute the script by the file name

The fifth script reproduces the behavior of the command STSADM -o migrateuser. More added value to come (batch migration and subsequent updates)

The sixth script:
  • dumps information about a SharePoint site group into an XML file
  • 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 format

The eighth script load all the Active Directory Users from the given OU to a given SharePoint contacts list
You can modify the script file for adapt the Active Directory connection string (With the possible Organization Unit) and the Contact list Name and URL
  • Set-UserInfoDetails "http://myWebApplication/sites/MySiteCollection" "My Contact ListName" "LDAP://OU=MYActiveDirectoryOU,DC=MySubDomain,DC=MyDomain,DC=COM"
The script manage the Insert and Update, not the delete, you can uncomment the "QuickCleanAllListItems" function call for that
  • QuickCleanAllListItems "http://myWebApplication/sites/MySiteCollection" "My Contact ListName"

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 it

The Thirteenth script create or list the SharePoint MOSS Personalized links

The 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 9: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 7: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 5: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 6:24 PM