I am facing a similar error as the Link provides. Is there a relevant SQL query for PS Query provided in the link to delete those entries? I did find an other technet article but the link seems to be broken

When i ran the below query

 `SELECT UPF.[NTName], Count(UPF.NTName)    FROM [UPA-Profile-DB].[dbo].[UserProfile_Full] as UPF with (nolock)  INNER JOIN [UPA-Profile-DB].[dbo].DNLookup as DN with (nolock)  ON UPF.RecordID = DN.RecordId Group BY UPF.NTName Having Count(UPF.NTName) > 1 Order by UPF.NTName `

I did get the result of usernames with 2 entries. Which user has to be deleted?

  • What are you using? UPSS or MIM? – Trevor Seward Nov 30 '18 at 18:26
  • I am using UPSS – Achiever SP Nov 30 '18 at 18:32

Your Answer

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

Browse other questions tagged or ask your own question.