Listing Domains Managed on a Plesk Server

I’ve learned the hard way that while directly altering Plesk’s database is almost never a good idea, the Plesk database ‘PSA’ holds a ton of useful information that’s not always readily exportable from the interface. Here are a couple of useful queries. The first simply exports a list of “standard hosted” domains. The second includes client information.

You’ll need to be logged in as root.

First, Get into MySQL and use the Plesk database, “psa”:

mysql -u admin -p`cat /etc/psa/.psa.shadow`;
use psa;

Query 1: List all the standard hosted domains, send the results to a csv file:

select name from domains where htype='vrt_hst' INTO OUTFILE '/tmp/domains.csv';

Query 2: Building on that, lets add client information and sort it to make it pretty:

select cname,name from domains, clients where cl_id = clients.id and htype='vrt_hst' order by cname,name INTO OUTFILE '/tmp/domains-client.csv';

Nothing earth shattering here, but it might save you 5 minutes.