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.