Is it possible to get all users under Profiles Missing from Import? I try to enter the wildcard character (*) by the GUI, but it don't work. Is there another solution?

If there is a powershell command, it is also ok.

enter image description here


Just enter the first letter of your domain (or your whole domain) and it will return the results.


There must be a PowerShell cmdlet but if you have access to the Database it might be quicker to find that information through below T-SQL (at least that's how I feel it :-))

replace "SP2013_UPA_Profile" with your UPA database name.

Hope this helps!

SELECT [PartitionID]
  FROM [SP2013_UPA_Profile].[dbo].[UserProfile_Full] with (nolock)
  where bDeleted <> 0
  • I would like to use this select query, but is not supported to do that. Was you talking about this powershell script? $upa = Get-spserviceapplication -name 'User Profile Service Application' Set-SPProfileServiceApplication $upa -GetNonImportedObjects $true – Ola Feb 24 '15 at 8:05
  • Bad idea, not supported. Don't do this. – Matthew McDermott Feb 24 '15 at 12:52
  • Is there another solution in powershell or programmatically(c#)? – Ola Feb 25 '15 at 8:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.