Results 1 to 5 of 5

Thread: [SOLVED] Query Zimbra db for messages matching criteria

  1. #1
    bobchauvin is offline Member
    Join Date
    Oct 2009
    Posts
    10
    Rep Power
    5

    Question [SOLVED] Query Zimbra db for messages matching criteria

    We need to be able to query messages stored in zimbra with various selection criteria, for ex:

    All messages for user sent between dates, with To containing some email address, where the subject contains some text.

    Anyone have any ideas?

  2. #2
    uxbod's Avatar
    uxbod is offline Moderator
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,016
    Rep Power
    24

    Default

    It would help if you were to update your profile with the following output so we know which version of ZCS you are running
    Code:
    su - zimbra
    zmcontrol -v

  3. #3
    bobchauvin is offline Member
    Join Date
    Oct 2009
    Posts
    10
    Rep Power
    5

    Default

    Profile updated... Release 6.0.1_GA_1816.UBUNTU8_64 UBUNTU8_64 NETWORK edition.

    We have 40 days of support (according to my Admin), so I wonder if I should re-ask under that related support login?
    Last edited by bobchauvin; 10-06-2009 at 08:09 AM. Reason: more details...

  4. #4
    bobchauvin is offline Member
    Join Date
    Oct 2009
    Posts
    10
    Rep Power
    5

    Default

    Also, If there is doc on querying via webservices (REST or SOAP) that would possibly work, but some SQL based query is preferred.

    Background: We use a middleware product called Handshake that allows us to profile a database and query it and display that data on our SharePoint server, etc.

  5. #5
    bobchauvin is offline Member
    Join Date
    Oct 2009
    Posts
    10
    Rep Power
    5

    Default

    The short answer from one of the internal Zimbra DB experts is that it is not viable, since to, from, cc, bcc, and other metadata is (with one or two exceptions) not saved in the database. Bummer.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Major Issue - 5.0RC2 NE to 5.0GA NE failed
    By DougWare in forum Installation
    Replies: 7
    Last Post: 01-06-2008, 09:56 PM
  2. Can't start Zimbra!
    By zibra in forum Administrators
    Replies: 5
    Last Post: 03-22-2007, 11:34 AM
  3. zmtlsctl give LDAP error
    By sourcehound in forum Administrators
    Replies: 5
    Last Post: 03-11-2007, 03:48 PM
  4. 4.5 Upgrade failure
    By brained in forum Installation
    Replies: 9
    Last Post: 03-03-2007, 03:30 PM
  5. dspam logrotate errors
    By michaeln in forum Users
    Replies: 7
    Last Post: 02-19-2007, 12:45 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
  •