How much data TSM backed up last night?

[J1gh2]

Hi Guys

I am trying to find out how much data TSM backed up last night or in the last 24 hours? What`s the best way to get this information? Also can I get the data backed up by storage pool?

Thanks in advance for your help.

 

[J1gh2]

I came across this statement and it seems ok for backup and archive:
SELECT cast(float(sum(bytes))/1024/1024/1024 as dec(8,2)) as "GB" FROM summary WHERE activity='BACKUP' AND end_time>current_timestamp-24 hours