0

Please login or register to vote for this query.

(click on this box to dismiss)

Lists all Duplicate account names

Q&A for SharePoint enthusiasts

-- Duplicate Name Finder
-- Lists all Duplicate account names

SELECT DisplayName,
 COUNT(DisplayName) AS NumOccurrences
FROM Users
GROUP BY DisplayName
HAVING ( COUNT(DisplayName) > 1 )
ORDER BY NumOccurrences desc

fork query

created nov 15 10 lord.quackstar