Update: I’ve written a better explanation of how to change user profile properties with powershell. I’ve learned a few things since this original post. New post here: http://www.practicalkungfu.net/2012/04/updated-sharepoint-2010-user-profile.html

This will get the my site location for each user who has created one. It should be possible to add some logic to only display the entries that aren’t NULL.

$mySiteUrl = “mysitehostURL”
$site = Get-SPSite $mySiteUrl
$context = Get-SPServiceContext $site
$profileManager = New-Object Microsoft.Office.Server.UserProfiles.UserProfileManager($context)
$profiles = $profileManager.GetEnumerator()
$Profiles | select PersonalSite

This is also a great way to get other data out of the UPS. You can see a list of the available properties and methods by doing the a $profiles get-member after using the above code. I’ve pasted them below for reference.

Name                           MemberType
—-                           ———-
Commit                         Method
CreatePersonalSite             Method
Equals                         Method
GetChanges                     Method
GetColleagueChanges            Method
GetCommonManager               Method
GetDirectReports               Method
GetEnumerator                  Method
GetExtendedReports             Method
GetHashCode                    Method
GetManager                     Method
GetManagers                    Method
GetMyDirectReportOrganizations Method
GetMyOrganizationChains        Method
GetMyOrganizations             Method
GetPeers                       Method
GetProfileValueCollection      Method
GetType                        Method
IsProfileOwner                 Method
RefreshManagers                Method
SID                            Method
ToString                       Method
Item                           ParameterizedProperty
Colleagues                     Property
CurrentChangeToken             Property
DisplayName                    Property
ID                             Property
Memberships                    Property
MultiloginAccounts             Property
Parent                         Property
PersonalizationLinks           Property
PersonalSite                   Property
PersonalUrl                    Property
ProfileManager                 Property
ProfileManagerBase             Property
ProfileSubtype                 Property
ProfileType                    Property
Properties                     Property
PublicOrganizationViewUrl      Property
PublicUrl                      Property
QuickLinks                     Property
RecordId                       Property
RemotePersonalSiteHostUrl      Property
Suggestions                    Property
ViewerRights                   Property