Counts mail that is > 5 years

5yearcounter

#!/bin/bash
# Counts for mail > 5 years
IAM=`id -un`
if [ "$IAM" != "zimbra" ]; then
    echo "You must run this script as the 'zimbra' user.  Please 'su - zimbra' first."
    exit 1
fi

for mboxgroup in `/opt/zimbra/bin/mysql --batch --skip-column-names -e "show databases like 'mboxgroup%'"`; do
    /opt/zimbra/bin/mysql --batch --skip-column-names -e "select count(*) from mail_item where date < unix_timestamp(now() - interval 5 year)" $mboxgroup;
done | xargs -n1 echo + | xargs expr 0