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 -----Original Message----- From: MC Matt Cooper (2838) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 10:18 AM To: [EMAIL PROTECTED] Subject: Anyone know how to have TSM script read an input file? Hello all, In the life of ever changing requirements... I must include in an e-mail sent to a PC user that they missed a backup, exactly how long it has been since they were backed up. I am scanning the log to see what schedules were MISSED. But now for each node that was missed I need to know the last date of a backup, not a 'accessed by TSM' (which is in the NODE DB) . I see that the SUMMARY DB has ALL the backups start and end dates. But what would be the logical way to approach this? I would think list off the nodes that failed and do some sort of select of the SUMMARY DB to find the last successful backup. 1) I am not sure how to ask for JUST the last successful backup of 1 node. 2) I am truly at a loss to figure out how to have this script read in a list of nodes to find out there last successful backups Has anyone done anything like this? An example could take me a long way. I am using TSM 4.1.5 on z/OS 1.1. If I can get all the info into records I am using SAS to format the e-mail messages. My TSM system has about 230 nodes in an 80% full 25GB data base. Hopefully I can do this in an efficient manner... Thanks in advance for all your help! Matt