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

Reply via email to