Viewing products/services in use?

[eger]

I would like to find a way to view which products/services are in use by clients. I thought I was able to do this before a long time ago. But I can't seem to find out how.

 

I would like to cleanup some of my products. But I am not sure which are being used and which are not.

 

Any ideas?

[bear]

Clients tab, choose "List all products/Services" from the dropdown. Click "search/filter" and search on whatever product you want to find. Gives a total at the top.

[eger]

I thought I saw a page once that showed an overview...

 

With lots of products that could be tedious work. I figured out how to mangle some SQL together to show this. Maybe this could be thrown together as an add-on module (unfortunately I don't know how those work yet).

 

SELECT `tblproducts`.`id` AS 'Product ID', `tblproducts`.`name` AS 'Product Name', COUNT( `tblhosting`.`id` ) AS 'In Use', `tblproductgroups`.`name` AS 'Group'
FROM `tblproducts`
LEFT JOIN `tblproductgroups` ON `tblproducts`.`gid` = `tblproductgroups`.`id`
LEFT JOIN `tblhosting` ON `tblproducts`.`id` = `tblhosting`.`packageid`
GROUP BY `tblhosting`.`packageid`

 

Hope this might help someone in the future!