How about this one.
select entity as "Storage Pool ", - cast(bytes/1024/1024 as decimal(10,3)) as " Total MB ", ' ' as " ", - substr(cast(start_time as char(26)),1,19) as "Start/Time ", - substr(cast(end_time as char(26)),1,19) as "End Date/Time ", - cast(substr(cast(end_time-start_time as char(20)),3,8) as char(8)) as - Length from summary where start_time>=current_timestamp - 22 hours and - activity='STGPOOL BACKUP' order by 3, entity Sung Y. Lee "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> wrote on 01/18/2007 11:41:54 AM: > Hi all, > > I have a script I can run that will tell me the amount of data backed up > the previous 24 hours, the amount of data archived the previous 24 hours > and restored. I am interested to know if anyone has a script that would > tell you the amount of data written to offsite tapes, either the past 24 > hours or a number of hours I specify. I'd like to compare that with what > my script reports to see if everything is getting sent offsite as it > should. I understand that, depending on the number of hours reported, it > would also include data written from reclamation which could skew the > numbers. > > Thank you, > > Geoff Gill > TSM Administrator > PeopleSoft Sr. Systems Administrator > SAIC M/S-G1b > (858)826-4062 > Email: [EMAIL PROTECTED] > >