2.27.2013

SharePoint 2010 - People Picker Configuration

There are so many nuances to this little tool in SharePoint. Configuration settings can only be done after installation using STSADM commands. Below are several resources I have found related to this topic.

Checking Accounts:
https://<SiteURL>/_layouts/people.aspx?MembershipGroupId=0
https://<SiteURL>/_catalogs/users/simple.aspx

People Picker Hide Inactive Accounts:
stsadm.exe -o setproperty -propertyname "HideInactiveProfiles" -propertyvalue "true"

Run These Command as SPFarm Account to Remove Old DBs:
stsadm -o sync -listolddatabases 1
stsadm -o sync –deleteolddatabases 1
stsadm -o sync –synctiming m:5 
(this is to alter the sync timing schedule in a DEV environment, default is 1 hour)

Awesome PowerShell Commands for Checking and Deleting Orphaned Users:
http://www.sharepointclowns.com/2011/04/find-and-delete-orphaned-users/

People Picker Resource Articles:
http://technet.microsoft.com/en-us/library/cc263196.aspx
http://technet.microsoft.com/en-us/library/gg602075(v=office.14).aspx
http://blog.helloitsliam.com/Lists/Posts/Post.aspx?ID=48

Resyncing an Account From AD:
Set-SPUser -Identity "<domain\username>" -web "<SiteURL>" -SyncFromAD

Manually Deleting Accounts:
1. In SQL: SELECT * FROM [WSS_Content_DatabaseName].[dbo].[UserInfo] WHERE tp_Login='DOMAIN\username'
2. Take note of the tp_ID
3. In IE, go to http://<your sharepoint site collection/_layouts/userdisp.aspx?ID=tp_ID, where tp_ID is the number you found from your select statement.
4. It should take you to the user's profile where you can click on the Delete User from Site Collection button.