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
I go at it from the other direction, easier to calculate.
Use the OCCUPANCY or AUDITOCC tables to sum up the total GB (or objects) in the
onsite vs. offsite pools.
At the time your BACKUP STGPOOL finishes, they should be the same (except for
any thing that has arrived since the BKUP STGPOOL st
