Export SharePoint 2013 User Profile Information Values In CSV Using PowerShell

In this blog you will learn how to export the User Profile service application properties in SharePoint Server 2013. The User Profile service is a shared service in SharePoint Server 2013 and this is responsible for SharePoint User Synchronization in various settings.

When you create site settings you need a user profile service application to sync with the data base to retrieve the audience settings and profile details.

Here I will quickly explain about how to configure the User profile application through the UI method,

Goto SharePoint 2013 Central Admin-->Application Management-->Manage Service Applications-->Service Applications tab to enable the ribbon--> Create a UPSA.

Here we will see about the Powershell method. It is a very simple one to create for admins.

GET ALL User profile properties

Syntax

# -----------------------------------------------------------------------------
# Script    :Export User Profile Information Value in CSV
# Author    : Gowtham Rajamanickam
# Date      : February 12 2017
# Version   :1.0
# -----------------------------------------------------------------------------
 Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue

$siteUrl = "https://gowtham.sharepoint.com"
$outputFile = "D:/sharepoint/Documents"
$Context = Get-SPServiceContext -Site $siteUrl
$userprofileManager = New-Object Microsoft.Office.Server.UserProfiles.UserProfileManager($Context);
$Userprofiles = $userprofileManager.GetEnumerator()

$collection = @()
foreach ($Userprofile in $Userprofiles) {

   $profileProperty = "" |
   select "FirstName", "LastName",  "AccountName", "PreferredName" , "Department" , "Manager" , "Office" , "Location" , "WorkEmail" , "Assistant" , "AboutMe" , "Language" ,"Role"
   $profileProperty.AccountName = $profile["FirstName"]
   $profileProperty.AccountName = $profile["LastName"]
   $profileProperty.AccountName = $profile["AccountName"]
   $profileProperty.PreferredName = $profile["PreferredName"]
   $profileProperty.Manager = $profile["Manager"]
   $profileProperty.Department = $profile["Department"]
   $profileProperty.Office = $profile["Office"]
   $profileProperty.Location = $profile["Location"]
   $profileProperty.WorkEmail = $profile["WorkEmail"]
   $profileProperty.Assistant = $profile["Assistant"]
   $profileProperty.AboutMe = $profile["AboutMe"].Value
   $profileProperty.Language = $profile["Language"]
   $profileProperty.Role = $profile["Role"]
   $collection += $profileProperty
}
$collection | Export-Csv $outputFile -.csv

Thanks for reading my blog.