Email címekkel kapcsolatos lekérdezések iRedMail rendszerben.

Minden domain aktív email címének lekérése:

ssh ladmin@mail 'sudo mysql -e "use vmail;select username, domain from mailbox where active=1;"'

Domain szerinti lekérdezéshez:

ssh ladmin@mail 'sudo mysql -e "use vmail;select username, domain from mailbox where active=1 and domain=\"pelda.hu\";"'

Update (2020-08-26):

while read m; do ma=($m);s=${ma[2]}/sieve/dovecot.sieve;if [[ -e $s ]];then [[ $(cat $s | grep redirect | wc -l) == "0" ]] && echo "${ma[0]}, " || while read sl; do sla=($sl);slaa=${sla[1]};slaa=${slaa//\"/};slaa=${slaa//\;/}; echo "${ma[0]}, ${slaa}"; done < <(cat $s |grep redirect);else echo "${ma[0]}, "; fi; done < <(sudo mysql -B -e "use vmail;select username, domain, concat(storagebasedirectory,\"/\",storagenode,\"/\",maildir) as path from mailbox where active=1 order by domain, name;") | sendmail admins@pelda.hu