Try
select node_name,filespace_name,cast((backup_end) as varchar(10)) as "Date"
from adsm.filespaces where (cast((current_timestamp-backup_end)day as
decimal(18,0))>2 )
or
select node_name,filespace_name,cast((backup_end) as varchar(10)) as "Date"
from adsm.filespaces where (cast((current_timestamp-backup_end)day as
decimal(18,0))>2 and cast((current_timestamp-backup_end)day as
decimal(18,0))<7 )
the first will give you any file space that hasn't backed up in the last 2
days
this can get long due to excluded file spaces and the such
thus the second will list file spaces that haven't backed up between -2 & -7
days, this will get rid of excluded file spaces (once the box has been
backing up for a week
Dwight E. Cook
Software Application Engineer III
Science Applications International Corporation
509 S. Boston Ave. Suit 220
Tulsa, Oklahoma 74103-4606
Office (918) 732-7109
|