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

List of domains by expiration date

Discussion in 'Plesk 9.x for Linux Issues, Fixes, How-To' started by lexam, Apr 2, 2009.

  1. lexam

    lexam New Pleskian

    22
    73%
    Joined:
    Jun 4, 2008
    Messages:
    15
    Likes Received:
    0
    Hi all,

    this is probably a very dumb question, but here goes: Is there any way in Plesk 9 to see a list of all the domains hosted which also shows their expiration date? I want to be able to see which is the next domain to expire... Is that too much to ask for?

    Thank you in advance
     
  2. JaimeG

    JaimeG Guest

    0
     
    Me too

    I miss the same feature. Is it really so hard? Seems that a slightly complex SQL query can be used to return the list by hand, but I cannot believe it's not implemented in Plesk.

    Nobody found a trick?
     
  3. lvalics

    lvalics Silver Pleskian Plesk Guru

    36
    43%
    Joined:
    Jun 20, 2003
    Messages:
    965
    Likes Received:
    32
    Location:
    Romania
    This feature can be found in Power Toys. Hope this help.
     
  4. Satoriya

    Satoriya Guest

    0
     
    You can get this information from Plesk database with a following query:

    [root@plesk860 ~]# mysql -uadmin -psetup psa -e "select d.name,from_unixtime(l.value) as 'expiration date' from Limits l join domains d on d.limits_id=l.id where l.limit_name = 'expiration' order by 'expiration date'"
    +-------------------------------+---------------------+
    | name | expiration date |
    +-------------------------------+---------------------+
    | tst.sw | NULL |
    | ppptest.com | 2009-12-19 00:00:00 |
    | biomicrobics.iloveliquid9.com | 2010-10-19 00:00:00 |
    +-------------------------------+---------------------+
    [root@plesk860 ~]#

    NULL - means 'Unlimited' or never expires other words.
     
Loading...