How to get a list of all websites published by Web Presence Builder?

Connect to the server via SSH.

Execute the following command:

# plesk db “select d.name as ‘Website’ from psa.domains d, psa.dom_param dp, sitebuilder5.site s where d.id=dp.dom_id and dp.param=’site_builder_site_id’ and s.uuid=dp.val and s.is_published is not null and d.status=0”

+————-+
| Website     |
+————-+
| example.com |
| example.org |
+————-+

Connect to the server via RDP.

Open Command Prompt as Administrator.

Execute the following command:

C:> plesk db “select d.name as ‘Website’ from domains d, dom_param dp where d.id=dp.dom_id and dp.param=’site_builder_site_id'”
+————-+
| Website     |
+————-+
| example.com |
| example.org |
+————-+