How to extract information about domains that use Sitejet in Plesk for Linux via the Plesk database?

Question

• How to extract the Sitejet clients from the psa database?
• How to extract website ID's for Sitejet Domains in Plesk?

Answer

To gather information about SiteJet Domains in Plesk like their website ID's and name, run the following steps:

1. Log into your server via SSH
2. Execute the following command:

# plesk db "SELECT dom_param.param, dom_param.val, domains.name FROM dom_param JOIN domains ON dom_param.dom_id = domains.id WHERE dom_param.param LIKE 'ext-plesk-sitejet%';"

The output you receive will be similar to the following:

# | param                          | val                        | name |
+---------------------------------------------------+------------+-------------------------------------------------+
| ext-plesk-sitejet-website_id                   | 816524 |       example.com |
| ext-plesk-sitejet-website_publication_time | 1722494567 | example.com |
| ext-plesk-sitejet-website_template_id | 380531 | example.com |
| ext-plesk-sitejet-not_published_notification_sent | true | example.net|
| ext-plesk-sitejet-website_id | 839236 | example.net |
| ext-plesk-sitejet-website_last_access_time | 1731024002 | example.net |
| ext-plesk-sitejet-website_id | 1131606 | example.org |
| ext-plesk-sitejet-website_last_access_time | 1734544383 | example.org |
+---------------------------------------------------+------------+----------------------------------------

The breakdown of the output is as follows:

• The name column shows the domain name that is using Sitejet.
• The val column shows the value of the specific Sitejet parameter.

• The param column shows the specific parameter to which the value belongs. 

  For example, in the above output, the the website id i.e. ext-plesk-sitejet-website_id  is the parameter, value is 816524 for example.com.