Results 1 to 3 of 3

Thread: MySql Query for All Calendar items

  1. #1
    Join Date
    Sep 2011
    Posts
    2
    Rep Power
    4

    Default MySql Query for All Calendar items

    Long story short, I'm trying to write a SQL query to select ALL the appointments, but based on how the databases are split up into the mailbox groups, I'm not quite sure how I'd accomplish this. It has to be done with a query because of our analytics software that will be connecting to it.

    Does anyone have an idea on how I'd do this, or if you can point me in the right direction it'd be greatly appreciated. Thanks.

  2. #2
    phoenix is offline Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,587
    Rep Power
    58

    Default

    Is this what you're looking for: Account mailbox database structure - Zimbra :: Wiki
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  3. #3
    Join Date
    Sep 2011
    Posts
    2
    Rep Power
    4

    Default Close

    That's close to what I'm looking for, but not quite there. I can't figure out though how I'd actually query for all calendar events at once though. With some events being on mboxgroup1 through mboxgroup99, I don't know how I'd do a
    SELECT * FROM mboxgroups.appointment WHERE type = 11;

    without doing SELECT * FROM mboxgroup1.appointment, mboxgroup2.appointment, ... mboxgroup99.appointment;

Similar Threads

  1. System crash leads to major MySQL corruption
    By Glider Guider in forum Administrators
    Replies: 1
    Last Post: 08-01-2011, 12:03 PM
  2. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 01:42 AM
  3. Delete items in calendar
    By aletomi in forum Administrators
    Replies: 1
    Last Post: 11-23-2007, 07:44 AM
  4. Replies: 0
    Last Post: 05-11-2007, 08:56 AM
  5. Free/Busy in Outlook only shows some calendar items, not all
    By graefen in forum Zimbra Connector for Outlook
    Replies: 6
    Last Post: 05-02-2006, 05:25 PM

Tags for this Thread

Posting Permissions

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