Plesk for Windows
Plesk for Linux
kb: how-to
how-to
Applicable to:
- Plesk for Linux
- Plesk for Windows
Question
How to get a list of all domains and their SSL certificates in Plesk?
Answer
-
Run the following MySQL query command (on Windows Server, start a command prompt as an Administrator):
-
to get a list of all domains with their own certificates:
# plesk db "SELECT c.id, c.name, r.rep_id, 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') OR r.rep_id IS NULL"
-
to get a list of all domains that use a default SSL certificate from server repository:
# plesk db "select www_root,certificate_id from hosting where certificate_id=1"
-
Comments
0 comments
Please sign in to leave a comment.