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 License Management menu: '
Sites published with Presence Builder'.
113223 [HOW TO] How to get site UUID and directory ID by name of Plesk domain?