Retrieve unused IP addresses in Plesk via CLI

Posted on by eliminyro

Retrieve a list of domains and their IP addresses:

plesk db "SELECT d.name, IF(ip.public_ip_address IS NULL, ip.IP_Address, ip.public_ip_address) AS 'IP' 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 WHERE ds.type='web';"

Retrieve unused IP addresses in Plesk via CLI:

plesk bin ipmanage -l | awk '{ if ($4 == 0 && $5 == 0) { print } }'

Run Plesk API request from CLI

Posted on by admin 
curl -kLi -H "Content-Type: text/xml" -H "HTTP_AUTH_LOGIN: admin" -H "HTTP_AUTH_PASSWD:verysecurepwd" -H "HTTP_PRETTY_PRINT: TRUE" -d @payload.xml https://plesk.example.com:8443/enterprise/control/agent.php
[System.Net.ServicePointManager]::ServerCertificateValidationCallback = {$true}
$request = New-Object System.Net.WebClient
$request.Headers.add('HTTP_AUTH_LOGIN','admin')
$request.Headers.add('HTTP_AUTH_PASSWD','verysecurepwd')
$request.Headers.add('HTTP_PRETTY_PRINT','true')
$response = $request.UploadFile('https://plesk.example.com:8443/enterprise/control/agent.php','.\payload.xml')
[System.Text.Encoding]::ASCII.GetString($response)