Results 1 to 3 of 3

Thread: SQL Query

  1. #1
    Join Date
    Oct 2006
    Location
    St Louis
    Posts
    27
    Rep Power
    9

    Default SQL Query

    As an admin I need to run a monthly query of all Zimbra users.

    There are a handful of fields I know I need, and probably a few more I'd want if I looked through a table layout document. Output to a flat ascii file, or a csv would be fine. I can take it from there.

    I'd like to list their user name, first name, last name, description, location, and class of service. I'd like to sort the whole thing by COS (500 users). Last login and some other fields may not be in the user tables, but I'd like to review that/those tables myself to know.

    Where can I find a doc on the tables list, and their fields for Zimbra?

    Finally, is there something unusual we'd need to do to make this happen? My techs look at me like I'm crazy and mumble when I request their feedback on this project.

    TIA... Jim

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

    Default

    zmprov is your friend. If you query the database directly that can be subject to change without notice and break your scripts. Alternatively it may be a good time to learn the SOAP interface

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

    Default

    I prefer to take your advice about zmprov, the SOAP interface sounds horrible to my enduser's ears

Similar Threads

  1. GALsync LDAP query in AD; mailnickname=Bug?
    By ypong in forum Administrators
    Replies: 6
    Last Post: 04-17-2012, 01:12 AM
  2. Zmmsgtrace - sql execute failed - error in SQL syntax
    By Edmund in forum Administrators
    Replies: 2
    Last Post: 03-19-2008, 02:04 PM
  3. Change the default mail sync query to a phone
    By phingers in forum Zimbra Mobile
    Replies: 1
    Last Post: 07-31-2007, 09:46 PM
  4. sql query to retrieve mails store path
    By banou in forum Developers
    Replies: 10
    Last Post: 05-02-2007, 07:53 AM
  5. Lotus migration
    By babou in forum Migration
    Replies: 15
    Last Post: 03-05-2007, 10:33 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
  •