SQL/SCRIPT amount being backed up daily?

[PaulWiley]

Currently looking through past discussions, but was hoping for some spoon feeding....

Does anyone have a handy-dandy sql for TSM 5.5 server to determine how much total data is being backed up daily to determine if my diskpool is large enough?

Thanks in advance,
P

 

[rmazzon]

This is a down and dirty select. You may need to adjust the decimal values and the dates are hard coded.

select cast(cast(sum(bytes) as decimal(18,4))/1024/1024/1024 as decimal(6,2)) from summary where activity in ('BACKUP','ARCHIVE') and start_time>='2012-06-19 18:00' and start_time<'2012-06-20 18:00'

 

[PaulWiley]

That is awesome! Thank you very much. That is exactly what I was looking for.