Have a look on the scripts archives on coderelief.
        http://www.coderelief.com/depot.htm

In the TSM Scripts -> Server Monitoring and Admin area there are a bunch
of Perl scripts, with a script called "tsm-node-check"

This parses the previous nights logs and e-mails the contact[s] of the
nodes with summary of details and e-mails the admins of the policy
domains a list of the most significant sessions.

Cheers, Suad
--
On Tue, Sep 25, 2001 at 12:59:33PM -0400, Marc Levitan wrote:
On Tue, Sep 25, 2001 at 12:59:33PM -0400, Marc Levitan wrote:
> I am looking for a script that will list the clients that backed up and how
> much data was backed up for the previous night and if they were successful.
>
> This is what I have:
>
> select ENTITY as Node_Name, BYTES as Bytes_Transferred, SUCCESSFUL from
> summary where activity='BACKUP' and start_time>='2001-09-23
> 00:00:00.000000' and bytes>0 order by entity
>
> The problem is that I have to change the Day/Time stamp before I run it.
> Is there a way to put a variable like today-1?  I have tried but am not
> successful.
>
> Does anyone have a better script?
>
>
> Marc Levitan
> Storage Manager
> PFPC Global Fund Services