• Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

List of domains by expiration date

lexam

New Pleskian
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
 
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?
 
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.
 
Back
Top