Articles in this section

See more

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

Avatar
Alexey Lapshin
Updated
Follow

Applicable to:

  • Plesk for Windows
  • Plesk for Linux

Symptoms

How to get a list of all websites which use Web Presence Builder?

Resolution

For Linux

  1. Connect to the server via SSH as root.

  2. 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

  1. Connect to the server via RDP.

  2. Open Command Prompt as Administrator.

  3. 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 |
    +-------------+

Comments

0 comments

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles