#!/bin/bash

OUTPUT_FILE="/tmp/list_account_with_aliases.csv"
all_accounts=$(zmprov -l gaa)

source /opt/zimbra/bin/zmshutil
zmsetvars

echo "EMAIL;ALIAS" > $OUTPUT_FILE
echo "Mengambil akun yang memiliki alias..."

for account in $all_accounts
do
    aliases=$(ldapsearch -H $ldap_master_url -w $zimbra_ldap_password -D uid=zimbra,cn=admins,cn=zimbra -x "(&(objectClass=zimbraAccount)(zimbraMailDeliveryAddress=$account))" | grep '^zimbraMailAlias:' | awk '{print $2}' | paste -sd "," -)

    if [ -n "$aliases" ]; then
        echo "$account;$aliases" >> $OUTPUT_FILE
    fi
done
echo "Data disimpan di: $OUTPUT_FILE"