How To Masterbate With An Sock

List of domains and IPs in Plesk

If you use Plesk and want a list of all your domains and the IP they use, just run this query from the mysql client with a user that has permissions to read from the psa database (this is the plesk database), for example, uses the same user credentials your "superadmin" of plesk. SELECT


i.ip_address, d.name psa.hosting FROM LEFT JOIN AS h
psa.domains h.dom_id = AS d ON LEFT JOIN
d.id psa.IP_Addresses h.ip_address_id AS i ON i.id = ;


If you want to summarize all the IPS, the number of domains that use domain and a sample, use this query SELECT


i.ip_address, COUNT (d.name) AS domains AS a FROM psa.hosting d.name LEFT JOIN AS h
psa.domains AS d ON = d.id
h.dom_id psa.IP_Addresses AS i LEFT JOIN ON
h.ip_address_id = GROUP BY i.id ORDER BY h.ip_address_id
h.ip_address_id, d.name