1 Topic by samtech

  • samtech
  • Member
  • Offline
  • Registered: 2015-12-21
  • Posts: 34

Topic: How to filter list of users based on properties set

==== Required information ====
- iRedMail version (check /etc/iredmail-release):      v0.9.5-1
- Linux/BSD distribution name and version: Debian 8
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Apache
- Manage mail accounts with iRedAdmin-Pro? yes
- Related log if you're reporting an issue:
====

How to get answered following most common queries

1. Get List of users who has forwarding set along with forwarded emails.

2. Get list of users who has Whitelist receipient set for Outbound emails.

Is there any way to get it from iRedAdmin-Pro panel ?

----

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

2 Reply by samtech

  • samtech
  • Member
  • Offline
  • Registered: 2015-12-21
  • Posts: 34

Re: How to filter list of users based on properties set

Is there anyone to help with this?

3 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,094

Re: How to filter list of users based on properties set

samtech wrote:

1. Get List of users who has forwarding set along with forwarded emails.
2. Get list of users who has Whitelist receipient set for Outbound emails.

Do you mean local users who have mail forwarding and whitelisted (outbound) recipients?

4 Reply by samtech

  • samtech
  • Member
  • Offline
  • Registered: 2015-12-21
  • Posts: 34

Re: How to filter list of users based on properties set

Yes, local users.

I manged to get #2 from amavis database. But #1 is still pending.

5 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,094

Re: How to filter list of users based on properties set

For #1, try SQL command like below:

USE vmail;
SELECT address FROM alias WHERE address <> goto AND islist=0 AND is_alias=0;
samtech wrote:

I manged to get #2 from amavis database.

It's easier to get it with "/opt/iredapd/tools/wblist_admin.py". Check our tutorial here:
http://www.iredmail.org/docs/manage.iredapd.html