Results 1 to 4 of 4

Thread: Server Statistics in Text Format

Hybrid View

  1. #1
    Join Date
    Jun 2007
    Location
    Philippines
    Posts
    193
    Rep Power
    8

    Default Server Statistics in Text Format

    Hi All,

    I could have missed it somehwere in the forum during my search, but i would like to know if there is a way or a process (whatever you may want to call it) to get a server statistical report in text or probably spreadsheet format?

    The graphical stat reporting in the Admin UI is definitely cool, but i need exact numbers like how many mail were spam, how many with virus, etc... for management reporting and justification.

    I did not see this information as well in the admin report (mail).

    Thanks in advance.

  2. #2
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    21

    Default

    The zimbra server stores stats in a csv format

    You can grab them from /opt/zimbra/log/

    Code:
    [zimbra@roadshow log]$ head zimbrastats.csv.2007-07-15  
    timestamp,lmtp_rcvd_msgs,lmtp_rcvd_bytes,lmtp_rcvd_rcpt,lmtp_dlvd_msgs,lmtp_dlvd_bytes,db_conn_count,db_conn_ms_avg,ldap_dc_count,ldap_dc_ms_avg,mbox_add_msg_count,mbox_add_msg_ms_avg,mbox_get_count,mbox_get_ms_avg,mbox_cache,mbox_msg_cache,mbox_item_cache,soap_count,soap_ms_avg,imap_count,imap_ms_avg,pop_count,pop_ms_avg,idx_wrt_avg,idx_wrt_opened,idx_wrt_opened_cache_hit,java_heap_MB,db_pool_size,mysql_opened_tables,mysql_slow_queries,mysql_threads_connected,innodb_pages_read,innodb_pages_written,innodb_bp_hit_rate,pop_conn,pop_ssl_conn,imap_conn,imap_ssl_conn 
    07/15/2007 00:00:49,,,,,,4,0.25,,,,,,,,,,,,,,,,0.00,,,209.520,0,507,249,1,6054,17205,,,0,0, 
    07/15/2007 00:01:49,,,,,,4,0.00,,,,,,,,,,,,,,,,0.00,,,210.437,0,507,249,1,6054,17205,,,0,0, 
    07/15/2007 00:02:49,,,,,,4,0.00,,,,,,,,,,,,,,,,0.00,,,210.456,0,507,249,1,6054,17205,,,0,0, 
    07/15/2007 00:03:49,,,,,,4,0.00,,,,,,,,,,,,,,,,0.00,,,210.456,0,507,249,1,6054,17205,,,0,0, 
    07/15/2007 00:04:49,,,,,,4,0.00,,,,,,,,,,,,,,,,0.00,,,210.456,0,507,249,1,6054,17205,,,0,0, 
    07/15/2007 00:05:49,,,,,,4,0.25,,,,,,,,,,,,,,,,0.00,,,210.456,0,507,249,1,6054,17205,,,0,0, 
    07/15/2007 00:06:49,,,,,,4,0.00,,,,,,,,,,,,,,,,0.00,,,210.456,0,507,249,1,6054,17205,,,0,0, 
    07/15/2007 00:07:49,,,,,,4,0.00,,,,,,,,,,,,,,,,0.00,,,210.456,0,507,249,1,6054,17205,,,0,0, 
    07/15/2007 00:08:49,,,,,,4,0.00,,,,,,,,,,,,,,,,0.00,,,210.456,0,507,249,1,6054,17205,,,0,0,

  3. #3
    Join Date
    Jul 2006
    Posts
    623
    Rep Power
    10

    Default

    All the information you are looking for is stored in the logger database, feel free to file an enhancement request and we can get those numbers added to the zmdailyreport output.
    Bugzilla - Wiki - Downloads - Before posting... Search!

  4. #4
    Join Date
    Jun 2007
    Location
    Philippines
    Posts
    193
    Rep Power
    8

    Default

    Thanks to your informative replym jholder and brian.

    Sure i will make a suggestion on things i think will make ZImbra better.

Similar Threads

  1. initializing ldap...FAILED(256)ERROR
    By manjunath in forum Installation
    Replies: 39
    Last Post: 06-07-2013, 11:27 AM
  2. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 01:42 AM
  3. need advice on configuring zimbra to work with fax server
    By pheonix1t in forum Administrators
    Replies: 0
    Last Post: 07-11-2007, 08:46 PM
  4. Error 256 on Installation
    By RuinExplorer in forum Installation
    Replies: 5
    Last Post: 10-19-2006, 10:19 AM
  5. Getting problems in FC4 while instalation
    By kitty_bhoo in forum Installation
    Replies: 13
    Last Post: 09-12-2006, 11:34 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
  •