Export SharePoint 2013 User Profile Information Values In CSV Using PowerShell

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.