Issue list of subscriptions with the IP Address

[Michael Huber]

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

not work with the new version of plesk

on the older version output have many subscriptions two IP's and this not help really

 

[Hex]

Both commands working on 18.0.28 CentOS 7.

 

[Kaspar]

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

not work with the new version of plesk

on the older version output have many subscriptions two IP's and this not help really

These command should be working without any issue. What OS are you running and version of Plesk?

And what does the command

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;"

output for you?

 

[Michael Huber]

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;"
+---------------------------+------+
| name | IPs |
+---------------------------+------+
| xxx.xxx | |
| xxx.xxy | |
and so ..

fresh installed Debian 10 and Plesk today installed