How to get list of all domains in Plesk with information about their IP addresses, DMARC status and SSL certificates?

Question

How to get a list of all domains in Plesk with information about their IP addresses, DMARC status and SSL certificates?

Answer

This information can not be viewed in the Plesk interface, however it is possible to get all this information from Plesk database:

1. Connect to the server using SSH.
2. Download report.sh.tar.gz from the attachment and unpack it:

   # wget https://plesk.zendesk.com/hc/article_attachments/12377319866775/report.sh.tar.gz
   # tar -xvzf report.sh.tar.gz

3. Add executable permissions to unpacked script:

   # chmod +x report.sh

4. Execute the script:

   ./report.sh

Information will be stored in the file report.txt in the same directory.