How to get a list of subscriptions and their IP addresses on Plesk server?

Plesk for Windows kb: how-to Plesk for Linux ABT: Group A

Applicable to:

How to get a list of subscriptions?

How to get a list of all primary/main domains?

How to get a list of subscriptions and their IP addresses?

Click on a section to expand

For Linux:

Connect into the server via SSH

Note: If direct SSH access to the server is not possible, contact server administrator for further assistance.
Get a list of subscriptions running the following command:

# plesk bin subscription --list
Get a list of subscriptions and their IP addresses running 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;"

Click on a section to expand

For Windows

Connect into the server via RDP

Note: If direct RDP access to the server is not possible, contact server administrator for further assistance.
Open CMD as administrator and run the command below:

C:\> plesk bin subscription.exe --list
Get a list of subscriptions and their IP addresses running the command below:

C:\> 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;"