contact details

[chandu]

Hi,

Just want to continue below link :

number of accounts and domain

it was solved so didnt disturbed that link.

our new client want report as below :

Employee ID Email ID Assigned Quota Used Quota account status
Here employee id field is not there in contact information.
SO i was think is it ok to use phone number field as employee id and get the report ..if it is ok then how to insert this details in exsiting account ?
any clue / command / script ?
Accounts are 1400+ so please help.

Thanks

[uxbod]

Why not use the Notes field instead ? You could use something like EMPID:99999 and then you can use EMPID as a search parameter.

[chandu]

Hi Uxbod,

Thanks for reply.

Yes we can use that field also . actually can use any field. BUt the problem is I have created 1510 accounts by using below script :

*
for i in `cat /usr/input`

do


echo -e $i

/opt/zimbra/bin/zmprov ca $i Password@12 displayName $i zimbraMailQuota 104857600 zimbraContactMaxNumEntries 500 zimbraPasswordMinLength 8 zimbraPasswordMaxLength 64 zimbraPasswordMinUpperCaseChars 1 zimbraPasswordMinLowerCaseChars 1 zimbraPasswordMinNumericChars 1 zimbraPasswordEnforceHistory 5


done


************************************************** ***

But by this script I only can get email ID and quota details. So i wanted to know how to insert "notes" filed with employee id details in EXISTING accounts ? is there any command for it..becasue its not feasible to manually update it for 1510 accounts.
Please help.

Thanks.

[chandu]

Hi,
Two more and urgent requirement..

1. we need report with last login details...like below :

Email ID Assigned Quota Used Quota account status Last login time


we are getting these details in admin console but how to get it in report ??

2. Our client want that their first name should be their password.
how can I set it for bulk account ? any clue ? the script which i am using for bulk account i have mentioned in above post.....

please help.

[uxbod]

Originally Posted by chandu

1. we need report with last login details...like below :

Email ID Assigned Quota Used Quota account status Last login time

we are getting these details in admin console but how to get it in report ??

zmprov ga {user@domain} zimbraLastLogonTimestamp

And the next question will be why is the timestamp so out of date. So have a read of :- [SOLVED] Last Login Time in Admin Console

Originally Posted by chandu

2. Our client want that their first name should be their password.
how can I set it for bulk account ? any clue ? the script which i am using for bulk account i have mentioned in above post.....

Not sure what you are asking

[chandu]

hi uxbod,

thanks for your reply.

for e.g email address is karen.smith@example.com then they want to set their first name as their password i.e. karen

And my pain is accounts are 1400+ ...as per above script i can't set any password policy due to this requirement.
if i use above script and add to change the password in next login then user has o use web interface to change it...as through MS office they wont able to change the password...so it will be unmanageable...

and my plan was set global password for all and once email solution get stable then user can raise the ticket with our helpdesk to change the password...

but just now i got this request...any suggesstion to fix this ???

thanks

[chandu]

in above script ..in input file ..i am only putting email addresses

[uxbod]

Do the accounts follow the same format eg. firstname.lastname@example.com ? If so then why not do the following

for i in `cat /usr/input`
do
  echo -e $i
  PASS=`echo $i | cut -f1 -d.`
  /opt/zimbra/bin/zmprov ca $i $PASS displayName $i zimbraMailQuota 104857600 zimbraContactMaxNumEntries 500 zimbraPasswordMinLength 8 zimbraPasswordMaxLength 64 zimbraPasswordMinUpperCaseChars 1 zimbraPasswordMinLowerCaseChars 1 zimbraPasswordMinNumericChars 1 zimbraPasswordEnforceHistory 5
done

[chandu]

Thanks for quick response...

ya we can use this script...

one more thing output of zimbraLastLogonTimestamp is coming in below format :

zimbraLastLogonTimestamp: 20090128181648Z

I couldnt understand this format. can you pls explain..or how to get the output in hh:mm:ss dd:mm:yy

thanks

[uxbod]

zmprov ga {user@domain.com} zimbraLastLogonTimestamp | egrep -v "(^#.*|^\s*$)" | sed -e "s/.*: \([0-9]\{4\}\)\([0-9]\{2\}\)\([0-9]\{2\}\)\([0-9]\{2\}\)\([0-9]\{2\}\)\([0-9]\{2\}\)\(.*\)/\3\/\2\/\1 \4:\5:\6/"

Have you tried the ZCS command zmaccts ? This is a perl script so you could take that, create your own version, and add into the additional information you need to extract.