PowerShell : How to pull user by Email from User Profile Store in SharePoint?

Question

I have a requirement where I need to get a user from User Profile Store in SharePoint but the only thing I have available is Email. This field is unique in HR system.

How can I pull user just by email? One option I thought was with Query but then I have 8000 plus users and that might take a while to run.

Looking for a way to do this in a efficient way. Any help is highly appreciated!!

Thanks

Answer 1

Try this;

Add-PSSnapin "Microsoft.SharePoint.PowerShell"
$emailAddress = "EMAIL ADDRESS YOU WISH TO QUERY"
$site = Get-SpSite $mySitesURL;
$context = Get-SPServiceContext $site;
$profileManager = New-Object Microsoft.Office.Server.UserProfiles.UserProfileManager($context)
$allProfiles = $profileManager.GetEnumerator()
foreach ($profile in $allProfiles) {
   if ($profile.GetProfileValueCollection("WorkEmail") -eq $emailAddress) {
      $profile
   }
}

This will return you a user profile object (Microsoft.Office.Server.UserProfiles.UserProfile) for the email address you have queried.

Answer 2

From what I've experienced, you can't directly fetch user profiles w/out the user login. Assuming you're fetching user profiles using the following code, there's two potential approaches I'd take if you only had email addresses.

$site = Get-SPSite https://root
$context = Get-SPServiceContext $site
$profileManager = New-Object Microsoft.Office.Server.UserProfiles.UserProfileManager($context)
$userProfile = $profileManager.GetUserProfile("domain\username")

Approaches:

1. Use AD PowerShell to get the user account and from there you can get their user login.

You should be able to install AD's PowerShell module if it's not already available. Then run the following to get their account:

$user = Get-ADUser -Filter {EmailAddress -eq "first.last@company.com"} -Properties *

You should then be able to construct their user login:

$userLogin = "domain\" + $user.SamAccountName

2. Fetch the user from My Site's "User Information List", then construct their user login.

Code:

$web = Get-SPWeb https://mysite
$user = $web.Lists["User Information List"].Items | where{$_["EMail"] -eq "first.last@company.com"}

You should then be able to construct their user login:

$userLogin = "domain\" + $user["UserName"]

I'm sure there's other potential ways to do this as well, but hopefully one of those proves sufficient.