[INFO] How to get a list of sites published with Web Presence Builder?

Refers to:

  • Plesk for Windows
  • Plesk for Linux
  • Web Presence Builder for Linux

Created:

2016-11-16 13:18:11 UTC

Modified:

2017-01-19 14:28:25 UTC

0

Was this article helpful?


Have more questions?

Submit a request

[INFO] How to get a list of sites published with Web Presence Builder?

Symptoms

I would like to get a list of Plesk domains and their sites published with Web Presence Builder (WPB).

Resolution

Run the following command on Plesk server as root in Linux and as Administrator in Windows to get the list of Plesk domains and their sites:

  • In Linux:

    ~# mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -e"select d.name as 'Plesk Domain', s.uuid as 'Site uuid' 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"
  • In Windows:

    cmd> "%plesk_dir%mysql\\bin\\mysql.exe" -uadmin -p******** -P8306 psa -Ne"select d.name as 'Plesk Domain',dp.val as 'Site uuid' from domains d, dom_param dp where d.id=dp.dom_id and dp.param='site_builder_site_id'"

The number of returned rows will match the value shown in License Management menu: ' Sites published with Presence Builder '.

Additional information

213958465 [HOW TO] How to get site UUID and directory ID by name of Plesk domain?

Have more questions? Submit a request
Please sign in to leave a comment.