On Fri, Jan 9, 2009 at 3:45 PM, Kauffman, Tom <KauffmanT AT nibco DOT com> 
wrote:

> Specifically, I'd like to get the byte-count backed up to my off-site
> copygroups by node name withing storage pool.
>
> The file  count would be nice, but I'll setlle for the byte count.



tsm: TSMSERVER1>select  stgpool_name,node_name, cast(sum(logical_mb/1024) as
decimal(10,1)) as "GB" , sum(num_files) as "#Objects" from occupancy where
stgpool_name in (select stgpool_name from stgpools where pooltype='COPY')
group by stgpool_name, node_name order by 1,2


>
>
> I'd also like to be able to get the start/end times and total data transfer
> by process.
>

You can get that pretty easily from the SUMMARY table.  You'll have to play
with it though, to pick out specifically which stgpool process you want.
Start here with:

select * from summary where activity='STGPOOL BACKUP'

Wanda