Results 1 to 3 of 3

Thread: zmmailbox search truncated subject

Hybrid View

  1. #1
    Join Date
    Feb 2009
    Posts
    11
    Rep Power
    6

    Default zmmailbox search truncated subject

    When I run this command:

    Code:
    zmmailbox -z -m admin@example.com s  -t message "Subject: T1*"
    I get this:
    Code:
    25. 111650  mess   GW1-LD-Local          T1 controller 0/0/0 --LD PRI-- on GW1 local-LD VOI  04/08/10 09:23
    The problem:
    As you can see the subject is truncated. How can I get a list of non-truncated subjects from a command line search?

    What I'm trying to do (in case you were wondering):
    I'm trying to take emails from monitoring alert and export them to csv so I can record the time/dates of device downtime.

  2. #2
    Join Date
    Jun 2011
    Location
    Caracas Venezuela
    Posts
    476
    Rep Power
    4

    Default

    Hi all,

    I know it's a old thread, there's any workaround for this?

    ccelis

  3. #3
    Join Date
    Jun 2011
    Location
    Caracas Venezuela
    Posts
    476
    Rep Power
    4

    Default

    I know a 4 year old thread... but i've found a solution

    Code:
    # Lists Messages with long Subjects 
    #
    # Usage ./mylista.sh usuario@domain.com YYYY-MM-DD as zimbra user
    #
    # Find MySQL database group
    zmbid=`zmprov gmi $1 |grep mailbox|cut -d" " -f2`
    zmi=`zmlocalconfig -s zimbra_mailbox_groups|cut -d" " -f3`
    zmgrp=`expr $zmbid % $zmi`
    
    # Create query -- Of course you can customize search to your needs
    echo "use mboxgroup$zmgrp" > /tmp/mylista.txt
    echo "select FROM_UNIXTIME(date) as fecha,';',subject from mail_item where type=5 and mailbox_id=$zmbid and FROM_UNIXTIME(date)>='$2' and unread=1 order by date; " >> /tmp/mylista.txt
    #
    mysql < /tmp/mylista.txt
    #
    rm /tmp/mylista.txt
    ccelis

Similar Threads

  1. Mail deferred with Connection timed out
    By Miklos Kalman in forum Administrators
    Replies: 7
    Last Post: 11-17-2012, 06:11 AM
  2. Why is Zimbra so buggy?
    By edwin.arneson in forum Users
    Replies: 50
    Last Post: 11-14-2011, 09:38 AM
  3. zmmailbox search limit ?
    By sysinternals in forum Administrators
    Replies: 3
    Last Post: 09-09-2009, 01:33 PM
  4. Search not working
    By zesta in forum Administrators
    Replies: 1
    Last Post: 03-18-2009, 02:08 AM
  5. search vs. searchConv
    By DarthJader in forum Developers
    Replies: 0
    Last Post: 05-30-2008, 03:26 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
  •