[HOW TO] Get list of domains and their IP addresses in one query?

Refers to:

  • Plesk for Linux
  • Plesk 12.0 for Windows

Created:

2016-11-16 12:46:13 UTC

Modified:

2016-12-21 19:10:17 UTC

0

Was this article helpful?


Have more questions?

Submit a request

[HOW TO] Get list of domains and their IP addresses in one query?

Question

How to get list of domains and their IP addresses in one query?

Answer

Run the following command from command line:

# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin -Dpsa -e"SELECT dom.id, dom.name, ia.ipAddressId, iad.ip_address FROM domains dom LEFT JOIN DomainServices d ON (dom.id = d.dom_id AND d.type = 'web') LEFT JOIN IpAddressesCollections ia ON ia.ipCollectionId = d.ipCollectionId LEFT JOIN IP_Addresses iad ON iad.id = ia.ipAddressId"

It will result output as below:

+----+-------------------------------+-------------+------------+
| id | name | ipAddressId | ip_address |
+----+-------------------------------+-------------+------------+
| 21 | domain1.tld | 1 | 10.0.0.1 |
| 36 | domain2.tld | 1 | 10.0.0.1 |
| 38 | domain3.tld | 2 | 10.0.0.2 |
| 26 | domain4.tld | 2 | 10.0.0.2 |
+------------------------------------+-------------+------------+

For Windows version see article #124159 .

Have more questions? Submit a request
Please sign in to leave a comment.