- Plesk for Windows
- Plesk for Linux
I would like to get a list of Plesk domains and their sites published with Web Presence Builder (WPB).
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:
~# 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"
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
Sites published with Presence Builder
213958465 [HOW TO] How to get site UUID and directory ID by name of Plesk domain?