Re: Select command for TOTAL DAILY BACKUP

[Richard Sims]

On Mar 22, 2007, at 2:13 PM, Luc Beaudoin wrote:

I have a blank

I want to know how many GB I'm taking in backup everyday  ...  I would
like the TOTAL not by nodes ...

any ideas

Something like the following, for backups ended thus far today:

SELECT Dec((SUM(BYTES) / (1024 * 1024 *1024)),15) as "BACKUP GB TODAY" -
from SUMMARY where (DATE(END_TIME) = CURRENT DATE) and ACTIVITY =
'BACKUP'

But the TSM accounting log is a better data source.

   Richard Sims