Page 1 of 2 12 LastLast
Results 1 to 10 of 20

Thread: contact details

  1. #1
    Join Date
    Dec 2007
    Posts
    445
    Rep Power
    7

    Default contact details

    Hi,

    Just want to continue below link :

    http://www.zimbra.com/forums/adminis...ts-domain.html

    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

  2. #2
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    25

    Default

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

  3. #3
    Join Date
    Dec 2007
    Posts
    445
    Rep Power
    7

    Default

    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.

  4. #4
    Join Date
    Dec 2007
    Posts
    445
    Rep Power
    7

    Default

    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.

  5. #5
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    25

    Default

    Quote Originally Posted by chandu View Post
    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 ??
    Code:
    zmprov ga {user@domain} zimbraLastLogonTimestamp
    And the next question will be why is the timestamp so out of date. So have a read of :- http://www.zimbra.com/forums/adminis...n-console.html

    Quote Originally Posted by chandu View Post
    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

  6. #6
    Join Date
    Dec 2007
    Posts
    445
    Rep Power
    7

    Default

    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
    Last edited by chandu; 03-27-2009 at 04:12 AM.

  7. #7
    Join Date
    Dec 2007
    Posts
    445
    Rep Power
    7

    Default

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

  8. #8
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    25

    Default

    Do the accounts follow the same format eg. firstname.lastname@example.com ? If so then why not do the following
    Code:
    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

  9. #9
    Join Date
    Dec 2007
    Posts
    445
    Rep Power
    7

    Default

    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

  10. #10
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    25

    Default

    Code:
    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.
    Last edited by uxbod; 03-27-2009 at 05:58 AM.

Similar Threads

  1. Replies: 12
    Last Post: 06-13-2013, 09:55 AM
  2. Problem with sync Contact groups in Mac Address Book
    By Tomas7799 in forum CalDAV / CardDAV / iSync
    Replies: 3
    Last Post: 11-11-2009, 08:36 AM
  3. Displaying attached messages inline
    By jbwiv in forum Users
    Replies: 2
    Last Post: 10-31-2008, 01:51 AM
  4. Replies: 3
    Last Post: 08-11-2007, 01:40 PM
  5. Outlook Migration Wizard + Contact Groups
    By thegeekiator in forum Migration
    Replies: 4
    Last Post: 07-13-2007, 04:00 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •