List of domains by expiration date

[lexam]

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

 

[JaimeG]

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?

 

[lvalics]

This feature can be found in Power Toys. Hope this help.

 

[Satoriya]

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.