Refresh the User Information List in SharePoint

If you are going into the User Information List, you will sometimes see it is not up to date. There are two jobs (User Profile to SharePoint Quick Sync and User Profile to SharePoint Full Sync). The quick sync will only add new member into your list and somehow it does not work sometimes. So you need to trigger the full sync.
The question is how.. there is no point in the UI to do so and not even PowerShell is able to start it.
The good old stsadm will rescue us.

There are two commands you need to execute in your SharePoint Managing Shell (as administrator).


Enter stsadm -o sync -listolddatabases 0 and you will get a list of Content Databases that where not update in the last zero days. In the list you will see the GUID of the database and the last sync date.

To update the lists enter stsadm -o sync -deleteolddatabases 0. This command will not delete anything in your databases. It will just reset the last sync date to never. So the full sync will be triggered. This job will clean up the complete list.

For more information about the stsadm sync command look at this post.

Comments

Popular posts from this blog

How to support multiple languages in WPF