1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Exporting Dedicated IP in custom format

Discussion in 'Plesk for Windows - 8.x and Older' started by alex.bumbacea, Jul 4, 2008.

  1. alex.bumbacea

    alex.bumbacea Guest

    0
     
    Hello,

    Few days ago i needed to get all dedicated ips and the domains assigned to it in a custom format. I tried to make the connections in the pas db, but i wasn't able to print the dedicated ips with multiple domains on them since ip_addresses.default_domain_id is 0 for that ones. Could you please provide help in this matter?

    Thank you,

    Alexandru Bumbacea
     
  2. alex.bumbacea

    alex.bumbacea Guest

    0
     
    For to tell. This is the task i run under mysql

    SELECT name, ip_address FROM domains
    INNER JOIN ip_addresses ON
    ip_addresses.default_domain_id=domains.id
    WHERE type='exclusive'
    LIMIT 0, 10;
     
Loading...