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
Alexander Verkooijen      SARA
Senior Systems Programmer Academic Computing
alexander AT sara DOT nl         Services Amsterdam
--------------------------------------------
=========================================================================