Get mail account lists to csv

Discussion in 'General' started by raczkowski1, Feb 7, 2022.

  1. raczkowski1

    raczkowski1 New Member

    I need get all mailbox addresses and forward entry for one client. ISPConfig show only part of address so I cant copy.
    Maybe some sql query.
    Thanks for any help
  2. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    Where do you see only part of an address?
    SQL query might show the information you want, but you have to specify exactly what is searched for and how is it displayed.
  3. raczkowski1

    raczkowski1 New Member

    In Emails --> Email Mailboxes
    Ex. "dariusz.racz@domai...." on first column

  4. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    Make the browser window wider. Or text smaller.
    raczkowski1 likes this.
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    or use the csv export function from phpmyadmin.
  6. nhybgtvfr

    nhybgtvfr Well-Known Member HowtoForge Supporter

    select email from mail_user;
    select source,destination,type from mail_forwarding;

    will get you all mail users and mail forwards and catchalls.
    you can filter it with where sys_groupid = '<id of client group>', but this assumes the mailbox/mailforward was created when logged in as that client, it may have the admin's id numbers instead.
  7. Jesse Norell

    Jesse Norell Well-Known Member Staff Member Howtoforge Staff

    Also can be used as a forward (as can sieve rules for that matter).
  8. raczkowski1

    raczkowski1 New Member

    Thanks , I change with table in gui by web tools and copy table to calc :)
    I have a question, can I get all emails account of client by ISPConfig API?
  9. till

    till Super Moderator Staff Member ISPConfig Developer

    Sure, you can query by any column of the tables using the ISPConfig remote API. Example:

    $sys_groupid = 1;
    $app = $client->mail_user_get($session_id, array('sys_groupid' => $sys_groupid));

Share This Page