Question Possible (CLI) command to check what vhosts do not have a SSL certificate

[nilsringersma_nl]

Hi Forum,

Plesk: 17.8.11
System: CentOS7

With the Advisor extension it is possible to show a view of all subscriptions and their SSL status. In example, a view of domains that do not use a valid SSL certificate.

I'm looking for a way to do the same thing on the command line. I want to perform this action for multiple servers and can do it via Ansible instead of the Plesk UI. This will save me a lot of time.

I've been looking at this article but haven't been able to come up with a command or script to do this for all vhosts.

Any advice or tips would be greatly appreciated!

 

[Niek_Beernink]

I think you can find the list via this command as root:

plesk db -Ne 'select name from domains where cert_rep_id = 0;'

 

[nilsringersma_nl]

Awesome! This worked perfectly.

I think you can find the list via this command as root:

plesk db -Ne 'select name from domains where cert_rep_id = 0;'