- Plesk for Linux
How to get a domain name, its mailboxes, to which reseller/client this domain belongs to and reseller's/client's email address by using the domain name via SQL request?
Connect to the server via SSH.
Execute the following command:
# plesk db "select a.name as 'domainname', b.mail_name as 'email', c.pname as 'resellername', c.email as 'reselleremail' from domains a, mail b, clients c where b.dom_id=a.id and c.id=a.cl_id and a.name='example.com';"