Be sure to include activity='ARCHIVE' when you use TDP products.

Kind regards
Thomas Rupp
UIS - Informatik Services
Vorarlberger Illwerke AG
MAIL:   thomas.rupp AT illwerke DOT at
TEL:    ++43/5574/4991-251
FAX:    ++43/5574/4991-820-8251

> -----Ursprüngliche Nachricht-----
> Von:  Alan Davenport [SMTP:Alan.Davenport AT SELECTIVE DOT COM]
> Gesendet am:  Dienstag, 12. Februar 2002 18:39
> An:   ADSM-L AT VM.MARIST DOT EDU
> Betreff:      Re: TSM Backup Script, bytes sent over last session.
> 
> Here is what I am using. It is a bit simplistic, but gets the job done;
> 
> 
> Name           Line       Command               Number     
> ----------
> ------------------------------------------------------------------
> LIST_BACK-     10         select bytes,entity from summary where
> activity='BACKUP' and
>  UP_TOTALS                 (date(end_time)=date(current_date-1 day)) and
> bytes>0 order
>                            by bytes desc 
>                20         select sum(bytes) as total_bytes from summary
> where         
>                            activity='BACKUP' and
> (date(end_time)=date(current_date-1  
>                            day))
> 
> 
> Alan Davenport
> Senior Storage Administrator
> Selective Insurance
> alan.davenport AT selectvie DOT com
> (973) 948-1306 
> 


------------------------------------------------------------------------------------------
---------------
Dieses eMail wurde auf Viren geprueft.
Dieses eMail wurde auf Viren geprueft.

Vorarlberger Illwerke AG
------------------------------------------------------------------------------------------
---------------
=======================================================================