---------------------------- Top of message ----------------------------
>>--> 04-02-02  08:26  S.SHEPPARD     (SHS)    Anyone know how to have T
>>--> 04-02-02  08:26  S.SHEPPARD     (SHS)    Anyone know how to have T

In our daily job which sends email notifications of missed/failed
backups, we also run a QUERY NODE F=D and a QUERY FS F=D and send the
output to a data set.  The QUERY FS data set includes the last backup
start and last backup complete data/time for each filespace.  You could
use this as the data source you're looking for.

Sam Sheppard
San Diego Data Processing Corp.
(858)-581-9668
-----------------------------------------------------------------------`
---------------------------- Top of message ----------------------------
---------------------------- Top of message ----------------------------
>>--> 04-02-02  08:20  ..NETMAIL     (001)     Anyone know how to have T
>>--> 04-02-02  08:20  ..NETMAIL     (001)     Anyone know how to have T
Date: Tue, 2 Apr 2002 11:18:23 -0500
From: "MC Matt Cooper (2838)" <Matt.Cooper AT AMGREETINGS DOT COM>
Subject: Anyone know how to have TSM script read an input file?
To: ADSM-L AT VM.MARIST DOT EDU
_________________________________Top_of_Message_________________________________

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

-----------------------------------------------------------------------`
=========================================================================