So, I've noticed a few times where the Help Desk has created multiple accounts for the same person. Not sure how that happens since we have some pretty tight process controls. Regardless, I'm looking for a way to list all AD users but only list them if the display name is not unique. I realize this is not perfect but I'm just looking for a way to verify on a regular basis. I have this report but dont know how to only list duplicate entries based on DisplayName. Any assistance would be appreciated:
Select Top 1000000 tblADusers.Username,
Case
When tblADusers.Displayname Is Null Or
tblADusers.Displayname = '' Then tblADusers.Userdomain + '\' +
tblADusers.Username
Else tblADusers.Displayname
End As Displayname,
Case
When Coalesce(tblADusers.IsEnabled, 0) = 0 Then 'False'
Else 'True'
End As EnabledInAD,
tblADusers.Department,
tblADusers.Office,
tblADusers.Description,
tblADusers.Userdomain,
'usersm.png' As Icon
From tblADusers
Order By tblADusers.IsEnabled Desc,
Displayname
