Torsten Olschewski wrote: > I'am not a MySQL guru. How can I find this users or how can I fix this > problem? There are about 30k users. Most of them from spam mail.
Try this MySQL query: SELECT COUNT(*), id, Name, EmailAddress from Users GROUP BY EmailAddress HAVING COUNT(*) > 1 order by Name, EmailAddress; That'll return a list of all the users with identical email addresses. You will then have to decide what to do with them - if they have only spam (or no) tickets, you can shred them without any danger. Graeme _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [email protected] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
