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