IMPORTANT Help needed

[atomicmak]

I have one thing to know on Plesk Reloaded 7.5.3.

the overall domains tab shows listing of domains with creation date. Can it possible to have expiry date also display there ?


actually i more than 300 domains on my plesk and i would need to know the expiry date of all domins at once.

can anyone help me out for this ?

 

[Gorgon@]

I don't see any way to do what you want in the CP. Maybe a direct query to the appropriate table in the database would get the info you want?

M

 

[atomicmak]

well i have downloaded sql of psa and looked for it but didnt find even

 

[jhobbs721]

SQL Statement to pull Domain Expirations

The two main tables you need are 'domains' and 'Limits'. You'll need to join these guys in order to get the information you're after.

The following SQL code will pull the Expiration entry for every domain in your domains table (whatever is configured). A value of -1 means there is no limit (i.e. Unlimited is checked!).

select DOM.name, LIM.value
from psa.domains DOM, psa.Limits LIM
where (DOM.limits_id = LIM.id) and LIM.limit_name = 'expiration';

This should get you the information you're after!

Joe

 

[atomicmak]

Thanks a lot buddy.

+----------------------------+------------+
| name | value |
+----------------------------+------------+
| domain1.com | 1174329000 |
| domain2.com | 1142793000 |
| domain3.com | 1128882600 |
| domain4.com | 1128882600 |
| domain5.biz | 1175365800 |
| domain6.biz | 1175365800 |


can you tell me why i see this kind of value ?

does there any calculation to see the exact expiry date ?

 

[atomicmak]

domain1.com has this value set in controlpanel what it shows


Resource Used Allowed
Validity period June 10, 2005 Oct 1, 2005

 

[jhobbs721]

I'm not sure on that one, but I'd bet it is a timestamp of some sort. I'd be interested to find out myself...

How about going into domain1.com, and extending their expiration date by 1 day? This would give you the delta for a full day, and would give you an idea of how much of a difference it makes.

When I get back to my machine, I'll take a look myself...

Joe