and, from the summary table:
 
1.  This will show you how much by node (backup and archive) for the past 24 
hours:
 
SELECT ENTITY AS NODE, -                             
   AVG(END_TIME-START_TIME) AS ELAPSED_TIME, -       
   CAST(SUM(BYTES/1024/1024) -                       
            AS DECIMAL(8,2)) AS "MB"  -              
FROM SUMMARY -                                       
WHERE ACTIVITY IN ('BACKUP','ARCHIVE') -             
   AND DAYS(CURRENT_TIMESTAMP)-DAYS(START_TIME)=1 -  
   GROUP BY ENTITY -                                 
   ORDER BY ELAPSED_TIME,MB  
 
2.  This will show you the total backed up (backup and archive) for the past 24 
hours:
                        
SELECT COUNT(ENTITY) AS "SESSIONS", -                
   CAST(SUM(BYTES/1024/1024) -                       
            AS DECIMAL(8,2)) AS "MB" -               
FROM SUMMARY -                                       
WHERE ACTIVITY IN ('BACKUP','ARCHIVE') -             
   AND DAYS(CURRENT_TIMESTAMP)-DAYS(START_TIME)=1 -  
   GROUP BY ACTIVITY                                 

        -----Original Message----- 
        From: Lawrence Clark [mailto:Larry_Clark AT THRUWAY.STATE.NY DOT US] 
        Sent: Fri 5/30/2003 12:01 PM 
        To: ADSM-L AT VM.MARIST DOT EDU 
        Cc: 
        Subject: Re: Need select command to show how much is backed up
        
        

        By client:
        select node_name, sum(logical_mb) as Data_In_MB, sum(num_files) as
        Num_of_files from occupancy group by node_name order by node_name asc
        
        >>> keross AT US.IBM DOT COM 05/30/03 12:34PM >>>
        I need a select command the will show me how much data is being backed
        up
        by my tsm server, can anyone help?
        
        Karla Ross