Having trouble wrapping my head around building a report of synced users via LDAP from two different domains we sync users from. What is happening, is if a user gets the same USERID as another user's USERID, which can happen with the same person if they happen to have IDs in both of the synced domains, and this ends up causing SSO login issues.
I can tell by looking at someone specific if they have accounts in both domains and if they match on this field. How can I build a report that shows me all the accounts that have a duplicate userID as another account? I am coalescing on the objectGUID during LDAP sync so SN knows unique values, but the naming convention is the same on both domains, and I would like to be proactive on identifying SSO login problems with this report. Thanks!
