How to export users data which reported to have validation error in Azure AD Connect \ Guy Bachar

Guy Bachar, Solutions Architect, Neway.


Based on a recent deployment I had with Azure AD Connect and Office 365

We encounter a problem with a list of users which were reported on the daily Identity synchronization Error Report from Microsoft to have the following problem:

Unable to update this object because the following attributes associated with this object have values that may already be associated with another object in your local directory services: [UserPrincipalName;]. Correct or remove the duplicate values in your local directory. Please refer to for more information on identifying objects with duplicate attribute values.

The solution for this problem is quite simple, changing the user UPN back to the default of problem as mentioned on the KB does the trick, but the problem is identifying all of those users in advanced, as the Identity synchronization Error Report contains couple of hundred of users.

Identifying the Users

  • Start a cmd prompt and go to %Program Files%\Microsoft Azure AD Sync\bin
  • Run: csexport “Name of Connector” %temp%\export.xml /f:x
  • The name of the Connector can be found in Synchronization Service. It will have a name similar to “ – AAD” for Azure AD.
  • Run: CSExportAnalyzer %temp%\export.xml > %temp%\export.csv
  • You now have a file in %temp% named export.csv which can be examined in Microsoft Excel. This file contains all changes which are about to be exported.
published also here
By Guy Bachar, Solutions Architect, Neway.

A highly talented and adaptable technology expert working in roles of greater responsibility. Successfully planned, architected and subsequently implemented a variety of responsive, intelligent and robust solutions. Motivated by business and technical challenges that require unique and out of the box solutions.

Focused on Microsoft Unified Communications and core infrastructure solutions as well as Cloud Services platforms (Azure and Office 365).

Facebook Comments