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
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