1 Topic by ired_mania

  • ired_mania
  • Member
  • Offline
  • Registered: 2019-06-20
  • Posts: 173

Topic: how to count number of sent e-mails

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release):
- Deployed with iRedMail Easy or the downloadable installer?
- Linux/BSD distribution name and version:
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):
- Web server (Apache or Nginx):
- Manage mail accounts with iRedAdmin-Pro?
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====
Is there any cmd or script to count number of sent e-mail by a user in a day ?

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,793

Re: how to count number of sent e-mails

You can try to count from SQL table "iredapd.smtp_sessions".

3 Reply by ired_mania

  • ired_mania
  • Member
  • Offline
  • Registered: 2019-06-20
  • Posts: 173

Re: how to count number of sent e-mails

ZhangHuangbin wrote:

You can try to count from SQL table "iredapd.smtp_sessions".

I am running iredmail0.9.8 on centos7, I dont have such a table in iredapd.

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,793

Re: how to count number of sent e-mails

Well, you can get the data in “amavisd” sql db too, not it’s much complex than the iredapd one.

You can upgrade iredapd to the latest 3.6 version to get the db:
Https://docs.iredmail.org/upgrade.iredapd.html