Results 1 to 3 of 3

Thread: [SOLVED] Reset the stats message count in administration

  1. #1
    Join Date
    Apr 2008
    Location
    Milan
    Posts
    45
    Rep Power
    7

    Default [SOLVED] Reset the stats message count in administration

    Is there a way to reset all stats in the Zimbra Admin Stats page?

    I messed up the logger service last week and the number of receved message was X times more thatn normal.
    I fixed the problem but now the graphs just shows the peak of 60k msg per hour :-P

    Thx
    AleX

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

    Default

    Code:
    su - zimbra
    logmysql
    use zimbra_logger;
    show tables;
    you could then delete the spurious entries from the tables.

  3. #3
    Join Date
    Apr 2008
    Location
    Milan
    Posts
    45
    Rep Power
    7

    Smile

    Quote Originally Posted by uxbod View Post
    Code:
    su - zimbra
    logmysql
    use zimbra_logger;
    show tables;
    you could then delete the spurious entries from the tables.
    For further reference
    I deleted the bad aggregated data from

    delete from mta_aggregate where period_start <= '2009-02-21 00:00:00';

    I then update the graph with
    /opt/zimbra/libexec/zmgengraphs >> /tmp/gengraphs.out 2>&1

    Thx

Similar Threads

  1. 'Couldn't access Yahoo! Zimbra Desktop server"
    By chirag1 in forum Error Reports
    Replies: 37
    Last Post: 06-12-2011, 05:14 PM
  2. Emails bouncing with "Error Text: 401,'null'"
    By sholden in forum Zimbra Connector for Outlook
    Replies: 27
    Last Post: 08-20-2008, 04:59 PM
  3. Server stats missing Message Count year graph
    By JonathanDelgado in forum Administrators
    Replies: 4
    Last Post: 05-18-2008, 08:36 AM
  4. Missing Stats Message Count / Message Volume
    By rhostager in forum Installation
    Replies: 15
    Last Post: 12-18-2007, 09:29 AM
  5. Reset Message Count
    By bhickey in forum Administrators
    Replies: 3
    Last Post: 03-13-2007, 09:23 AM

Posting Permissions

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