Server Statistics in Text Format

[randall]

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.

[jholder]

The zimbra server stores stats in a csv format

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

[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,

[brian]

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.

[randall]

Thanks to your informative replym jholder and brian.

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