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
--------------------------------------------
