Question How to get all the customer name and email addresses for active subcriptions?

[WebHostingAce]

Hi,

How to get all the 'Customer Name' and 'Email Address' for active subscriptions unless subscription is expired or suspended by Admin.

Thank you.

 

[WebHostingAce]

Seems like this is possible by Joining Client and Domain tables in PSA DB.

I will update this thread.

 

[IgorG]

In a hurry, something like:

select cname,pname,email from clients where id in (select cl_id from domains where webspace_status=0);