Question Which domain uses a specific SSL/TLS Certificates

[Mike73d]

Hi to all, there is a way to view which domain uses a specific SSL/TLS Certificates. I need to delete a certificate that is assigned to 2 domains, and I would not check one by one of the 50 domains I manage.

My configuration: Plesk Onyx Version 17.5.3 Update #28

Thanks Michele

 

[IgorG]

You can use following command for getting list of all ceritificates with related domain name:

# plesk db "select c.id, c.name, d.name from certificates c left join Repository r on (c.id = r.component_id) left join domains d on (r.rep_id = d.cert_rep_id) where r.rep_id not in (select val from misc where param = 'cert_rep_id')"