I use following:

dsmadmc > Select sum(cast(bytes/1024/1024 as decimal(10,3))) as "Backuped
MB" from summary where start_time>current_timestamp - 1 day and
activity='BACKUP'

The above is 1 long line.

If runnig from within a script run dsmadmc with -ID -PASSW and -DATAONLY=YES
Parameters


regards
juraj


-----Ursprüngliche Nachricht-----
Von: Justin Case [mailto:justin.case AT DUKE DOT EDU]
Gesendet: Dienstag, 30. März 2004 17:37
An: ADSM-L AT VM.MARIST DOT EDU
Betreff: PERL question for dsmaccnt.log queries ?


Hi all I am not a PERL programmer so I could use some help with a script
that would query the
TSM accounting log (dsmaccnt.log) to pull out the amount of data backed up
in a 24 hour period (last 24 hours).
If someone could share it with me that would be great. Or if someone knows
of a better method
to compute the daily amount of data backed up by TSM server too..

Thanks

Justin