Here is the one we use to show us nodes not backed up in two or more days:


/*                                              */
/* macro file to select filespaces that haven't */
/* completed a backup in more than 2 days      */
/*                                              */
set sqldatetimeformat i
set sqldisplaymode w
set sqlmathmode r
commit
select left(node_name,16) as node_name, -
       left(filespace_name,32) as file_space, -
       backup_end, -
       current_date - date(backup_end) as days_delinquent -
 from filespaces -
  where (days(current_date) - days(backup_end) >= 2)



Phil Bone
Sr. Systems Consultant
Network Services, Infrastructure Management
Office: 706.596.5928
Fax: 706.596.5950
Email: pbone AT aflac DOT com
Email: philbone AT mindspring DOT com