1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Question Which domain uses a specific SSL/TLS Certificates

Discussion in 'Plesk Onyx for Windows' started by Mike73d, Nov 10, 2017.

  1. Mike73d

    Mike73d New Pleskian

    1
    20%
    Joined:
    Nov 10, 2017
    Messages:
    1
    Likes Received:
    0
    Location:
    (VR) Italia
    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

    DeleteSSLCert.JPG
     
  2. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,572
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    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')"
     
Loading...