Hi all I wanted to know the users with multiple alias so i wrote this small script
Maybe it can be of some help mysql -s -u root -e "SELECT deliver_to from dbmail.aliases WHERE deliver_to not like '[EMAIL PROTECTED]' GROUP BY deliver_to HAVING count(deliver_to)>1" > /tmp/001 while read CHOICE do USER=`mysql -s -u root -e "SELECT userid from dbmail.users WHERE user_idnr='$CHOICE'"` echo "==================================================" echo "Alias of $USER" echo "==================================================" dbmail-adduser s $USER | grep "@" echo " " done</tmp/001 Bien à vous Jacques Beaudoin Agent d'administration Les services des technologies de l'information et des communications Commission scolaire de la Pointe de l'Île Montréal, Québec, Canada
