Get-UserProfiles – Get your own user profile report
Ever wanted to check your profile store in terms of usage or correct data for a specific property in all profiles?
Download this tiny script to accomplish your mission.
.\Get-UserProfiles.ps1 -PropertyConstant [PropertyConstant]
Check this site for all OOB Property Constants http://msdn.microsoft.com/en-us/library/microsoft.office.server.userprofiles.propertyconstants_fields.aspx
The script needs to be run – of course on a server that is part of the Farm where your User Profile Service sits on.
SharePoint Guru