SPProfileDump 

Introduction

This script enumerates through the user profile manager for a given site collection and would extract information about all profiles from the profile store.

Scenarios 

In SharePoint, we come across issues with profiles not being consistently updated with property values after an import operation. There could be numerous reasons for this; albeit a change in the import connection or the inability to reach and fetch information from a designated Directory server. Besides, the Central Admin UI doesn’t present a holistic view of all user profiles; neither is there an easier way to navigate through hundreds of profiles within the UI.

SPProfileDump would extract all profile information to a comma delimited (SPProfileDump.CSV) file. Additionally, it would also create a SPProfileProperties.TXT file that would contain the very basics of each profile property. You can open the SPProfileDump.CSV file in a tool like Excel and use filtering to view data the way you want. For example, find how many profiles have come through a specific OU or per say, how many users do not have a valid PictureURL. 

Script 

Step 1: Modify the script to suit your environment. 

You will have to open the script in an editor like notepad.exe, get bottom to line 79, and replace the value for the $url variable with the site URL you want. The site URL you specify will be used to obtain details about the User Profile Service Application from which the site consumes user profiles. 

$url = "http://sp2010:5000"

DumpProfiles($url)

Write-Host All content will be written to [Environment]::CurrentDirectory

 
$url = "http://sp2010:5000" 
 
DumpProfiles($url) 
 
Write-Host All content will be written to [Environment]::CurrentDirectory 

Step 3. Review data. You can use Excel or a similar tool to open the SPProfileDump.csv file.

Additional References 

User Profile service application overview - http://technet.microsoft.com/en-us/library/ee662538%28v=office.14%29.aspx

Accessing the User Profile Store Using the Object Model - http://msdn.microsoft.com/en-us/library/ms574336%28v=office.14%29.aspx

Plan user profiles - http://technet.microsoft.com/en-us/library/ee721054%28v=office.14%29.aspx

Photo Management in SharePoint 2010 - http://blogs.msdn.com/b/spsocial/archive/2011/01/07/photo-management-in-sharepoint-2010.aspx

Adding SharePoint 2010 PoweShell cmdlets to your PowerShell ISE - http://www.harbar.net/archive/2010/05/03/adding-sharepoint-2010-poweshell-cmdlets-to-your-powershell-ise.aspx