This will give amount backed up for 1 day (You may have to add Archives to the 
query)

select sum(cast(bytes/1024/1024/1024 as decimal(6,3))) "Total GB Backup" from 
summary where start_time>=current_timestamp - 1 day and activity='BACKUP'

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Owings, Don
Sent: Tuesday, August 31, 2004 3:25 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Select for Tape Use


Why you ask?  Because I'm having to justify ordering tapes and in order to do 
that I have to organize the data in order create some type of forecasting.  
What I'm looking for is a down and dirty select statement that just shows the 
previous nights usage.  Maybe it's in TSM but I haven't found it, plus I'm 
dealing with TB's of data so I need it consolidated.

Hope that clarifies what I'm trying to do.


Don

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
David E Ehresman
Sent: Tuesday, August 31, 2004 2:22 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Select for Tape Use


> I'm looking for a select statement that shows exactly what tapes were
used the previous night
>and what was written to the tapes.

Why?  TSM keeps track of all that so you don't have to.