Symptoms
How to get a list of all websites which use Web Presence Builder?
Resolution
For Linux
-
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 |
+————-+
For Windows
-
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 |
+————-+