Powershell Get Replacement info from User Profile for all users

Question

I want to extract info regarding Username and Replacements from the users profile properties for all users and have it written to a csv file.

Maybee through a powershell script so it can run in a scheduled task.

Being new to Powershell and SharePoint, I need some assistance!

I am using SharePoint 2010.

Answer 1

Assuming you want this information consumed by some other application, you could just use a SQL view to grab the information you want: http://iedaddy.com/2012/03/sharepoint-2010sql-view-to-get-user-profile-property-bag-values/

Or if you're looking to use the timer to export the CSV for audit historical purposes here's a post from when I had to read a CSV into the UPS, obviously just reverse the process: http://iedaddy.com/2010/06/sharepoint-2010-updating-user-profile-properties-with-powershell/

Of course, if your using a timer job to kick off the process make sure you set your context to the mysite web app to grab an instance of the UPS.

Answer 2

In this post: http://salvatoredifaziosharepoint.blogspot.it/2012/06/powershell-get-list-of-users-that-use.html I wrote a powershell script to get the users of my farm and print a custom property. You can use it and expand it to wrote the information in a CSV file.

Meanwhile this is the code of the post:

$url = "http://mysharepointsite/"
$site = Get-SPSite $url
$context = Get-SPServiceContext $site
$pMgr = New-Object Microsoft.Office.Server.UserProfiles.UserProfileManager($context)
$enum = $pMgr.GetEnumerator()

while ($enum.MoveNext()) {
  $currUser = $profiles.Current
  $name = $currUser.DisplayName
  $customProp = $currUser["MyCustomProperty"]
  Write-Host "$name;$customProp"
}