Cacher is the code snippet organizer for pro developers

-- Plesk domain structure
-- http://pleskhacker.com/all-tables/domains-all-tables/psa_domains/


-- Show domains
-- Output: name, id, status, and hosting type
mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -Ns -e "SELECT domains.name, domains.id, domains.status, domains.htype FROM domains"

-- Only show active domains that are not suspended or disabled domains
-- Output: name, hosting type
mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -Ns -e "SELECT domains.name, domains.htype FROM domains WHERE domains.status = 0"

-- Only show active domains, and exclude alias forwards as well
-- Output: name
mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -Ns -e "SELECT domains.name FROM domains WHERE domains.status = 0 AND domains.htype = 'vrt_hst'"

-- 
mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -Ns -e "SELECT * FROM domains"
-- id, cr_date, name, displayName, dns_zone_id, status, htype, real_size, cl_id, cert_rep_id, limits_id, params_id, guid