Find all customers using a specific addon

[sol2010]

I need to delete an discontinued product addon, but WHMCS complains that it is already assigned to a client.

Since I have a lot of clients, I'm looking for a way to query to which client(s) that product addon is currently assigned

- Alternatively - another method to force the deletion of the product addon ?

 

Thanks

 

[brian!]

4 minutes ago, sol2010 said:

Since I have a lot of clients, I'm looking for a way to query to which client(s) that product addon is currently assigned

have you tried using, from the admin area, clients -> service addons and then using the search/filter to specify the exact addon that you're looking for ? that should give you a list of current users of that product addon.

you could do it with a SQL query, but using the admin search options should be easier.

[sol2010]

Doh !  Thanks @brian!  Appreciate the helpful nudge in the right direction 😉  

Solved!