Get a report about the number of active domains of each client

[MaRiOsGR]

Hello,

 

is there any way to get the a report or something like that with the number of active domains per client?

I would like to know who has the most.

[stormy]

I have been trying to download the CSV export of domains and try to filter in Excel but I can't get to that list.

[SeanP]

Try this SQL query:

 

SELECT tblclients.firstname, tblclients.lastname, tblclients.companyname, tblclients.email, COUNT(tbldomains.id) AS 'domains' 
FROM tbldomains 
INNER JOIN tblclients 
ON tblclients.id = tbldomains.userid 
GROUP BY tbldomains.userid 
ORDER BY domains DESC;

[stormy]

That's great, thanks!

 

I've been tinkering with this for the past few hours (I'm not a coder!) and arrived at this one myself, which is similar:

 

SELECT tblclients.id, tblclients.firstname, tblclients.lastname, tblclients.email, COUNT( tbldomains.domain ) AS domains
FROM tbldomains
INNER JOIN tblclients ON tblclients.id = tbldomains.userid
AND tbldomains.status =  'Active'
GROUP BY userid
ORDER BY  `domains` DESC 

 

- - - Updated - - -

 

Someone should turn this into a nice report…