Count Duplicate Names

The following SQL query counts duplicate computer names. The first query looks for duplicate names only. If you have an issue where client records are not populating canonical names (OU path in AD), the second query look for duplicate names that have at least one client record with NULL for the canonical name. /* Count Duplicate Names */…