we have a shared scanner and to reduce error and make things faster, I combine everyone's autocomplete entries for easy lookup from the scanning app. here is how to get everyone's autocomplete entries. hope it helps someone else

Code:
 mysql -ss -e "SELECT metadata FROM zimbra.mailbox_metadata WHERE mailbox_id IN (SELECT id FROM zimbra.mailbox) AND section='CONTACT_RANKINGS'" |\
 tr ':' '\n' |\
 sed 's/d1//g' |\
 perl -ne'if(/[\w\.\-\_]+@([\w\-\_]+\.)+[A-Za-z]{2,4}/g){print "$&\n"}' |\
 sort -u