[SOLVED] Query Zimbra db for messages matching criteria

[bobchauvin]

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?

[uxbod]

It would help if you were to update your profile with the following output so we know which version of ZCS you are running

su - zimbra
zmcontrol -v

[bobchauvin]

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?

[bobchauvin]

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.

[bobchauvin]

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.