Wednesday, 3 November 2010

SharePoint 2010 – how to view/list all imported User Profiles?

Applies to: SharePoint 2010

If you encounter an issue during the user profile import process, how can you view/list all imported user profiles to start troubleshooting? Or, you may simply want to view the complete list of profiles imported from AD.

Below is a note from Microsoft Tech Support which I found useful;

It seems that there is no built-in method to list out all the users’ profile and associated properties. However, all the users profiles are stored in the SQL database “User Profile Service Application_ProfileDB_XXX” > table “dbo.UserProfile_Full”. You can run a SQL query command “Select * from dbo.UserProfile_Full” to list all the users.

No comments:

Post a comment

Please include your email address with comments.