PowerShell: Script to Fetch all User's Data from User profile in SharePoint 2013

Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue

    

$siteUrl =  "Enter here Central admin sharepoint URL"

$serviceContext = Get-SPServiceContext -Site $siteUrl

$profileManager = New-Object Microsoft.Office.Server.UserProfiles.UserProfileManager($serviceContext);

$profiles = $profileManager.GetEnumerator()

$fields = @(

            "SID",

            "ADGuid",

            "AccountName",

            "FirstName",

            "LastName",

            "PreferredName",

            "WorkPhone",

            "Office",

            "Department",

            "Title",

            "Manager",

            "AboutMe",

            "UserName",

            "SPS-Skills",

            "SPS-School",

            "SPS-Dotted-line",

            "SPS-Peers",

            "SPS-Responsibility",

            "SPS-PastProjects",

            "SPS-Interests",

            "SPS-SipAddress",

            "SPS-HireDate",

            "SPS-Location",

            "SPS-TimeZone",

            "SPS-StatusNotes",

            "Assistant",

            "WorkEmail",

            "SPS-ClaimID",

            "SPS-ClaimProviderID",

            "SPS-ClaimProviderType",

            "CellPhone",

            "Fax",

            "HomePhone",

            "PictureURL"

           )

$collection = @()

foreach ($profile in $profiles) {

   $user = "" | select $fields

   foreach ($field in $fields) {

     if($profile[$field].Property.IsMultivalued) {

       $user.$field = $profile[$field] -join "|"

     } else {

       $user.$field = $profile[$field].Value

     }

   }

   $collection += $user

}

$collection | Export-Csv -Path "E:\Output\sharepoint_user_profiles.csv"