- changed status to resolved
Statistics
How Can I get summary information about emails count
How many messages had been sent and delivered for users from one domain in some period of time
user | send | resive |
---|---|---|
user1@doamin.com | 1234 | 1231 |
… | … | … |
Comments (3)
-
repo owner -
reporter I have mor then 1000 users from few domains it is hard to whose one …
I did it by sql
select v_messages.from, count(todomain) from v_messages where fromdomain = "domain.com" group by v_messages.from
select v_messages.to, count(todomain) from v_messages where todomain = "domain.com" group by v_messages.to
I have to convert value of sent to do data format eg. 1546246938
| id | piler_id | from | fromdomain | to | todomain | subject | size | direction | sent | retained | arrived | digest | bodydigest | deleted |
| 1 | 400000005c29db251feca15c0045abcf74b8 | user@doain.com | domain.com | undisclosed-recipients@no.domain | no.domain | test | 16496 | 0 | 1546246938 | 1861779739 | 1546246939 | ca15b68899146a6eafde8aa506a1aa6f45b25cc67737f8517af5d3625ac94f3f | 750bddb549e587f6b84ce04dc86abcba5b4fa05ac44dd72bbd06eb7203f41d20 | 0 |
-
repo owner OK, good job.
- Log in to comment
As an administrator user click on the monitor menu, archive accounting.