How to get a list of subscriptions?
How to get a list of subscriptions and their IP addresses?
Connect to the server via SSH;
- To get a list of subscriptions run the command below:
# plesk bin subscription -l
To get a list of subscriptions and their IP addresses run the command below:
# plesk db "SELECT DISTINCT d.name, GROUP_CONCAT(DISTINCT(IF(ip.public_ip_address IS NULL, ip.IP_Address, ip.public_ip_address)) SEPARATOR ', ') AS IPs FROM domains d JOIN DomainServices ds ON d.id=ds.dom_id JOIN IpAddressesCollections ipc USING(ipCollectionId) JOIN IP_Addresses ip ON ipc.ipAddressId=ip.id RIGHT JOIN Subscriptions s on s.object_id=d.id WHERE d.id IS NOT NULL GROUP BY d.name;"