The servers current date is 2000-09-08 but today we have 2000-08-08.
What is the reason for this discrepancy?
TSM Server is VM/ESA 3.1.2.50
and yes - we are also interested in Version 4.1 for VM !!!
Freundliche Gruesse - kind regards
Werner Sailer
___________________________________________________________________
J. Eberspaecher GmbH & Co. Internet: http://www.eberspaecher.de
Kaufm. Rechenzentrum mailto:[EMAIL PROTECTED]
Eberspaecherstr. 24 phone: +49-711-939-0972 fax: -0668
D-73730 Esslingen Germany
--------Original--------------
On 04-Aug-00 Forgosh, Seth wrote:
> I'm sure that I've seen this answer before but I just can't seem to locate
> it. Does anyone have a select statement that will result in only those
> filespaces that have not completed a backup for the past X days? If so,
> could you please share it with me. Thanks in advance for your help.
>
> Seth Forgosh
This one gives you a list of filespaces that haven't completed a backup
in 5 days.
select filespace_name as "Filespace", \
node_name as "Node Name", \
days(current_date)-days(backup_end) as "Days since last backup" \
from filespaces \
where (days(backup_end) < (days(current_date)-5))
Regards,
Alexander
--------------------------------------------
Alexander Verkooijen SARA
Senior Systems Programmer Academic Computing
[EMAIL PROTECTED] Services Amsterdam
--------------------------------------------