Hi,

I'm running Zimbra for three clients and I get different results across three clients when I check the amavis table in the zimbra_logger database with the following query:

logmysql zimbra_logger -e "select min(arrive_time),max(arrive_time),disposition, status, count(*) from amavis group by disposition, status"

On the OpenSource Version 3.1.1_GA_394.RHEL4, the query returns lots of records:
+---------------------+---------------------+-------------+------------+----------+
| min(arrive_time) | max(arrive_time) | disposition | status | count(*) |
+---------------------+---------------------+-------------+------------+----------+
| 2006-08-22 22:46:34 | 2006-09-22 00:32:03 | Blocked | INFECTED | 83 |
| 2006-08-22 22:46:43 | 2006-09-22 13:50:28 | Blocked | SPAM | 913 |
| 2006-08-26 00:44:30 | 2006-09-22 00:24:55 | Passed | BAD-HEADER | 22 |
| 2006-08-22 20:31:37 | 2006-09-22 13:57:05 | Passed | CLEAN | 1784 |
| 2006-08-22 22:46:42 | 2006-09-22 13:31:59 | Passed | SPAM | 822 |
+---------------------+---------------------+-------------+------------+----------+


On an Open source v4.0GA, the query returns:
+---------------------+---------------------+-------------+----------+----------+
| min(arrive_time) | max(arrive_time) | disposition | status | count(*) |
+---------------------+---------------------+-------------+----------+----------+
| 2006-08-28 05:59:24 | 2006-09-18 18:07:26 | Blocked | INFECTED | 6 |
+---------------------+---------------------+-------------+----------+----------+


On a network edition v4.0 (trial), the query returns no records as there are no
records in this table:
logmysql zimbra_logger -e "select count(*) from amavis; select count(*) from amavis_aggregate"
+----------+
| count(*) |
+----------+
| 0 |
+----------+
+----------+
| count(*) |
+----------+
| 0 |
+----------+


Any ideas as to why this table would be empty or near-empty?

Thanks in advance for your assistance.

Rgds - Angus