[ Zimbra Script ] export data accout ( FirstName, LastName, displayName, email )

by M. Anwar Wednesday, January 07, 2015 0 comments windows categories zimbra

Buat script pada direktori tmp

Masuk ke user zimbra dengan menggunakan perintah su - zimbra

Jalankan perintah sh /tmp/export.sh /tmp/hasil-export.csv

Jika proses sudah selesai, data dapat diambil/dilihat pada file hasil-export.csv pada direcroty tmp.

berikut script nya

==============================================================

RESULT=$1

if test -f $RESULT; then

rm -rf $RESULT

fi

TMPFILE=/tmp/userattr

for user in `zmprov -l gaa`; do

echo "getting $user attributes"

zmprov ga $user > $TMPFILE

gn=`cat $TMPFILE | grep ^givenName | cut -d: -f2 | sed -e 's/^ *//'`

sn=`cat $TMPFILE | grep ^sn | cut -d: -f2 | sed -e 's/^ *//'`

dname=`cat $TMPFILE | grep ^displayName | cut -d: -f2 | sed -e 's/^ *//'`

name=`cat $TMPFILE |grep ^zimbraMailDeliveryAddress | cut -d: -f2 | sed -e 's/^ *//'`

echo "FirstName: $gn, LastName: $sn, displayName: $dname, email: $name" 

echo "$gn,$sn,$dname,$name" >> $RESULT

done